DeleteSql property with stored procedure

BRUNO · Post by **BRUNO** » Sun 11 May 2008 20:29

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

Plash · Post by **Plash** » Mon 12 May 2008 07:38

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.