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 ?
SQL Query
Re: SQL Query
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
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
Oleg Yershov
Re: SQL Query
Hy,
thank you. I had tried, but the result still empty...
thank you. I had tried, but the result still empty...
Re: SQL Query
Use LAGER1 instead of {LAGER1} (without braces)
You must specify variable name only
You must specify variable name only
Oleg Yershov