Hi, Jagadeesh
I would suggest you 2 solutions:
1. to use a function to edit these fields. That way you will be sure
that you will not forget to update both tables.
2. use a trigger on master table. If I understand you - the history
table could be filled using trigger, when data in master table changes.
That way you could change only master table in your application.
Good luck!
Jagadeesh rašė:
Hello Gurus,
Is it possible to update two table using single sql statement? huh?
let me be clear
I have table master with state and date field. And in history table I
have same fields i.e., state and date. I'm writing an update statement
to set 'open' state records to 'closed' state after 7. both table can
be joined using id.
Any thoughts?
Thanks
--
Julius Tuskenis
Programavimo skyriaus vadovas
UAB nSoft
mob. +37068233050
