Error with multiple statements and exception returns result instead exception
Posted: Wed 22 Mar 2017 19:20
Hello.
We have a TMSQuery with multiple resultsets turned on.
Now we got a query like this:
SELECT 1;
SELECT 2;
THROW 50000, ‚Error‘, 1;
The query returns the SELECT 1, but we expect an exception.
If we only have the „SELECT 1“ without „SELECT 2“ it will return nothing, because oft the exception.
Can you give us an advice?
Best regards
We have a TMSQuery with multiple resultsets turned on.
Now we got a query like this:
SELECT 1;
SELECT 2;
THROW 50000, ‚Error‘, 1;
The query returns the SELECT 1, but we expect an exception.
If we only have the „SELECT 1“ without „SELECT 2“ it will return nothing, because oft the exception.
Can you give us an advice?
Best regards