RoboTask forum

Hy, I had a problem with SQL Query.
I open Database, no error.
Then I do a DB Exec SQL, no error
DB Close, no error
Messagebox the Result, empty

When I use the SQL Query at SQl Studio it works with a result. Anyone can help me , why I get no result ?

Do you want to see the SUM?
DB Exec SQL action just execute the SQL statement. It has no any output. You can get row affected option. But this is depends on database kind.

1. 1-st line in your expression is not necessary. You can write ...[tWarenLger].kWarenLager = 1 in SQL
2. You must use DB Loop to extract some data from database. You expression returns only one row and one field

Hy,
thank you. I had tried, but the result still empty...

Use LAGER1 instead of {LAGER1} (without braces)
You must specify variable name only

Yes, thank you. Now it works