Update on various fields with the same sql statement

[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.

[mdaems]

Example?

[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.