lmmolinerocasares wrote:

> In a Delphi application I need to update some of the objects of a
> database in the client location, I use the standar IBExpress Delphi
> component TIBSQL, I assign the SQL property with the command, call
> ExecQuery, and everything is almost fine. I can add new columns to an
> existing table, I can create new tables, new foreing keys, new
> indexes, etc.
> But I can't create a new stored procedure. If I include the SET TERM
> statement I got an error message 'TERM token unknown', and of course
> if I do not include the statement I got an error -104.
>
> Does anyone know how can I create a new stored procedure in Delphi?

It's simple, don't use SET TERM at all. Just put the entire CREATE
PROCEDURE statement and execute it.

--
Milan Babuskov
http://fbexport.sourceforge.net
http://www.flamerobin.org