Page 1 of 1

Update on various fields with the same sql statement

Posted: 19.04.2012, 16:50
by eletronicashow
is there a way to update two tables in several different fields and using the same sql statement would have any examples.

Thank you.

Posted: 25.04.2012, 21:44
by mdaems
Example?

Posted: 28.04.2012, 12:46
by amarildolacerda
On database you can use triggers. With delphi you can use TZUpdateSQL to intercept insert, update, delete records. Maybe with some hack of TZUpdateSQL you be able to do something like to update two tables.