PSQL extensions problem (EXECUTE STATEMENT)

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!

Make sure you have the latest version of IBExpert of your other tool.


With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL Server.
Upscene Productions
http://www.upscene.com

if it is latest version of ibexpert, be sure that you enetered the right server version in database registration.

Best Regards

Holger Klemt

Get the 2004 FB Conference DVD with 40 Hours of Session Videos
for just 99 Euro http://www.h-k.de/cd/

The most Expert for InterBase and Firebird --- www.ibexpert.com
HK Software - Huntestrasse 15 - 26135 Oldenburg - Germany
Phone/Fax +49 700 IBEXPERT (42397378) www.h-k.de
Training and Support for Delphi, InterBase, Firebird, AS/400

How to EXECUTE STATEMENT 'delete from employee where name = 'AAAA'';
Thank you very much

Probably like:
How to EXECUTE STATEMENT 'delete from employee where name = ''AAAA'''

(doubling the single quotes to two single quotes)


With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL Server.
Upscene Productions
http://www.upscene.com

Thank very much