TMyQuery - How to process if more the one table has to updated

Discussion of open issues, suggestions and bugs regarding MyDAC (Data Access Components for MySQL) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Thomas J.
Posts: 95
Joined: Mon 21 Nov 2005 12:16
Location: Germany

TMyQuery - How to process if more the one table has to updated

Post by Thomas J. » Tue 04 Dec 2007 07:50

Hello support,
I use the TMyQuery component for selecting data from more then one table. I join 3 views and show these data in a grid. No the user changes data which has to be modified in more the one table. How can achieve an update for more the one table?
Can I enter more the one statement in SQLUpdate?

Thanks Thomas
Top
Antaeus
Posts: 2098
Joined: Tue 14 Feb 2006 10:14

Post by Antaeus » Wed 05 Dec 2007 08:16

Yes, you can use more than one statement, but only on MySQL servers supporting multistatement queries.
Another way is to use stored procedure calls in update SQL properties.
Top
Post Reply

Return to “MySQL Data Access Components”