Page 1 of 1

DeleteSql property with stored procedure

Posted: Sun 11 May 2008 20:29
by BRUNO
Hello,
is possible to put on the property DeleteSql of a TIBCquery a call to a stored procedure and that this will be executed when delete some record?
if possible then,
What can I do?

thank you

Posted: Mon 12 May 2008 07:38
by Plash
If you are working with InterBase or FireBird you can assign a SQL statement to the SQLDelete property like the following:

Code: Select all

EXECUTE PROCEDURE My_proc(:field1, :field2)
You can also generate this statement automatically. Open the query editor and go to the Stored Proc Call Generator tab; select the stored procedure name and 'Delete' statement type. Then click the 'Generate' button.