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.
- screenshot_20230108_151414.png (14.21 KiB) Viewed 1473 times
SQL Query
SQL Query
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 ?
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 ?
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...
- Snipaste_2023-01-09_11-37-38.png (33.66 KiB) Viewed 1451 times
Re: SQL Query
Use LAGER1 instead of {LAGER1} (without braces)
You must specify variable name only
You must specify variable name only
Oleg Yershov