Helen,

> Advice: As a beginner, don't try to do this. A stored procedure
> declaration is a complex DDL statement that can't be executed via a
> single-statement dynamic SQL component such as TIBSQL.

--8<-- snip

> SET TERM ^^ ;

I have to disagree with you here.

SET TERM is used to signal ISQL (or the Windows versions of the tool),
and it's script processor - not IB itself. In turn, ISQL will send each
statement
to IB/Fb.

I use TQuery like components all the time and I create procedures/triggers
etc with it just fine.

A CREATE PROCEDURE _is_ a single statement.


With regards,

Martijn Tonies
InterBase Workbench - the developer tool for InterBase & Firebird
Firebird Workbench - the developer tool for Firebird
Upscene Productions
http://www.upscene.com

"This is an object-oriented system.
If we change anything, the users object."