Subject Creating a stored procedure in a Delphi application
Author lmmolinerocasares
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?
Which component should I use?

Luis Miguel Molinero
Las Rozas - Madrid (Spain)