Devart Forums

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

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.