<< ROLLBACK | IBEBlock | FOR EXECUTE STATEMENT ... DO >>

EXECUTE STATEMENT ... AS DATASET

Syntax

 execute statement 'select field1 from table1' as dataset dset;

or

 stmnt = 'select field1 from table1'; 
 execute statement stmnt as dataset dset; 

Unfortunately in pre-2008.12.14 IBExpert versions this statement conflicts with the new Firebird 2.5 clause AS USER (EXECUTE STATEMENT ... AS USER ...;), so you will need to ensure that your IBExpert version is from 2008.12.14 or newer.

back to top of page
<< ROLLBACK | IBEBlock | FOR EXECUTE STATEMENT ... DO >>