On 24-9-2012 8:23, Svein Erling Tysvær wrote:

> EXECUTE BLOCK RETURNS(TheID integer)
> AS
> BEGIN
> INSERT INTO i (PATH) VALUES ('\somewhere\over\the\rainbow') RETURNING ID
> INTO TheID;
> SUSPEND;
> END

Thanks!

That works fine in FlameRobin (with set terms added), unfortunately the
fidgety compiler completely loses it with this statement:
EIBDatabaseError : : PrepareStatement :
-Dynamic SQL Error
-SQL error code = -901
-undefined message number

... seems I'll have to bite the bullet and get the generator value... or
accept the minimum compiler version should be higher.

Next on my list will probably be testing whether EXECUTE BLOCK works on
FPC... :(

Thanks a lot,
Reinier