Milan

Right. Without SET TERM, I can create stored procedures in Delphi, but
I still have problem with one specific procedure. It works in IBExpert
but not inside Delphi. Maybe I did something wrong, I'll keep
investigating.

Thanks

Luis Miguel Molinero
--- In firebird-support@yahoogroups.com, Milan Babuskov <milanb@k...>
wrote:

> 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