Hi,

> yes am unable to create stored procedure... am getting error like
> "Dynamic SQL Error, SQL Error Code = -104, Token unknown - line 1,
> char 5 term" am using Delphi 6, with Firebird. I have even tried
> creating with IBAccess but of no use.
> pls help me out...

Which component are you using? Are you using a script component? Don't
use a query or DSQL component, since they probably don't permit to use
more than one DDL statement at a time, and your sequence is composed
of 3 DDL statements.

Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.accramed.ca)