Hi

I have found this bit of code example and I think I will work for me.

Thanx for the tip Martijn

M

STMT1 = 'SELECT RDB$RELATION_NAME FROM RDB$RELATIONS';
L1:
FOR EXECUTE STATEMENT :STMT1 INTO :RNAME DO
BEGIN

>>> "Moegamat Alexander" <alexanderm@...> 2008/03/05 04:23:51 pm
>>>

Ooops Sorry the FB version 203 Win32 Build

>>> "Martijn Tonies" <m.tonies@...> 2008/03/05 04:19:29 pm >>>

Hi,

It depends on your version of Firebird, but you didn't mention the
version you're using.

Firebird 1.5 has [FOR] EXECUTE STATEMENT that can be
used to execute dynamic SQL in PSQL code.

Take a look at the Release Notes.

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB,
Oracle &
MS SQL Server
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com