Subject | Creating a stored procedure in a Delphi application |
---|---|
Author | lmmolinerocasares |
Post date | 2005-03-03T17:29Z |
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)
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)