Trouble with TMyQuery.SQLDelete

jarot · Post by **jarot** » Wed 25 Jan 2006 03:14

With BDE, i can modify the generated query at SQLInsert, SQLUpdate or SQLDelete. Especially when I wanted to do some cascading delete or update.

Something like this:

-- I added this
DELETE table_detail
WHERE field1 = :old_key1

-- automatically generated
DELETE table_master
WHERE field1 = :old_key1

However, it does not work with MyDac. Error. And I can't use semicolon to separate each command either.

Need help, please.

swierzbicki · Post by **swierzbicki** » Wed 25 Jan 2006 10:00

You can MySQL let the job for you !
Be sure to works with InnoDB table and set the appropriates foreigns keys.

Ikar · Post by **Ikar** » Thu 26 Jan 2006 13:18

Delphi and MyDAC don't allow such complex statements in SQLDelete. It's implied that only one record in the simple dataset is processed. To solve your problem try to use stored procedure or trigger (if your MySQL server supports them), or try to handle BeforeDelete event of your dataset, or any other manual way.