Update on various fields with the same sql statement

Forum related to Firebird

Moderators: gto, cipto_kh, EgonHugeist

eletronicashow
Fresh Boarder
Fresh Boarder
Posts: 1
Joined: 19.04.2012, 16:44

Update on various fields with the same sql statement

Postby eletronicashow » 19.04.2012, 16:50

is there a way to update two tables in several different fields and using the same sql statement would have any examples.

Thank you.

User avatar
mdaems
Zeos Project Manager
Zeos Project Manager
Posts: 2766
Joined: 20.09.2005, 15:28
Location: Brussels, Belgium
Contact:

Postby mdaems » 25.04.2012, 21:44

Example?
Image

amarildolacerda
Junior Boarder
Junior Boarder
Posts: 30
Joined: 12.08.2011, 12:42
Location: Brazil
Contact:

Postby amarildolacerda » 28.04.2012, 12:46

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.


Return to “Firebird”

Who is online

Users browsing this forum: No registered users and 1 guest