>Hi list,
>
>Firebird 2.5 Linux server.
>
>I'm trying to work around a bug in the FreePascal 2.6.0 compiler that thinks all INSERT statements never return data. This >bug has been worked on since but 2.6.0 is the last stable version so I'd prefer to be able to support that.
>
>I'm trying to fool the compiler and rewrite my query into something like SELECT (INSERT INTO i (PATH) VALUES >('\somewhere\over\the\rainbow') RETURNING ID) AS TheID FROM IMAGES i
>
>Any suggestions?

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

HTH,
Set