Re: [Firebird-devel] PSQL extension problem (EXECUTE STATEMENT)

[Tuan <tua...@ya...>]

How to EXECUTE STATEMENT 'Delete from employee where name = 'AAAA'';
Thanks in advance for your help

""Daniels"" <da...@sp...> wrote in message
news:cf2hqs$l0f$1...@ne......
> I have installed Firebird 1.5.1.4481 on Windows and wanted to use EXECUTE
> STATEMENT in stored procedure, to use a dynamically constructed query.
>
> I wrote just as in examples:
> CREATE PROCEDURE TEST
> AS
> DECLARE VARIABLE SQL VARCHAR(100);
> begin
>     SQL = 'delete from employee';
>     EXECUTE STATEMENT :SQL;
> end
>
> I use IBExpert (have tried also other tools) and during procedure
> compilation the parser fails at EXECUTE STATEMENT just as if it doesn't
> recognize it.
> The message is:
>
> Invalid token.
> Dynamic SQL Error.
> SQL error code = -104.
> Token unknown - line 6, char 11.
> STATEMENT.
>
> Are there any other actions I should take to use PSQL extensions added in
> Firebird 1.5 release?
>
> Thanks in advance for your help!
>
>
>
>
> -------------------------------------------------------
> This SF.Net email is sponsored by OSTG. Have you noticed the changes on
> Linux.com, ITManagersJournal and NewsForge in the past few weeks? Now,
> one more big change to announce. We are now OSTG- Open Source Technology
> Group. Come see the changes on the new OSTG site. www.ostg.com
> Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
>