Updating tables - Select / Union all statement

[rogeriobrito]

Hi.

I've a TZquery using a select / union all statement to join 2 tables in a Datagrid.
When I edit the data in the datagrid the tables are not updated.
Is there a way to do that?

Its a Mysql database.

Thanks a lot.
Rogerio

[mdaems]

You will have to use a TZUpdateSQL component. Select/Union all can't be resolved by the TZQuery component because of 'too complex'. How you do that can you find easily in Delphi Help. Just look for 'TUpdateSQL Component'. Behaviour should be similar/equal.

Mark

[rogeriobrito]

Yes mdaems, that's it,

Thank you very much.

[]s
Rogerio