meta data for this page
FOR EXECUTE STATEMENT ... DO
Syntax
FOR EXECUTE STATEMENT <select-statement> INTO <var> [, <var> ...] DO <compound-statement> <select-statement> :: = Any SELECT statement. <var> :: = A PSQL variable, optionally preceded by “:”
Example
create procedure DynamicSampleThree ( TextField varchar(100), TableName varchar(100) ) returns ( LongLine varchar(32000) ) as declare variable Chunk varchar(100); begin Chunk = ''; for execute statement 'select ' || TextField || ' from ' || TableName into :Chunk do if (Chunk is not null) then LongLine = LongLine || Chunk || ' '; suspend; end
(Source: Firebird 2.1 Language Reference Update, 10 July 2009)
It should be noted that the Firebird 2.0 and IBEBlock statements, FOR EXECUTE STATEMENT … DO, are almost but not totally identical: in the case of IBEBlock it is possible to select into the only variable:
for execute statement 'select field1, field2, field3 ...' into :myvar do ...
In this case it is possible to access selected field values using indices:
myvar[0] myvar[1] myvar[2]
or
myvar['FIELD1'] myvar['FIELD2'] myvar['FIELD3']