Page 1 of 1

Updating tables - Select / Union all statement

Posted: 04.12.2007, 16:38
by 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

Posted: 05.12.2007, 09:28
by 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

Posted: 05.12.2007, 13:29
by rogeriobrito
Yes mdaems, that's it,

Thank you very much.

[]s
Rogerio