October 25, 2002 at 4:46 am
i have 3 tables table1,table2,table3 in which they have one to one
relation ship annd table1 is the main table other 2 are subset of
table1.here in table 2 and table3 contains some additional coloumns
other than in table1.
when am deleting a record from table1 curresponding coloumn is getting
deleted either from table2 or table3.but when am updating (a common
field of all the tables)in table1 the curresponding record in table2 or
table3 is not getting updated.what is the problem how can i solve it?
is there any way?
October 25, 2002 at 8:39 am
Sounds like you may not have turned on cascading updates (sql 2k) or you didn't build a trigger to cascade updates (sql 7).
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
October 26, 2002 at 12:50 am
i have checked cascaded updates and deletes under cascaded inserts and updates by going the properties of the relationships in the data diagrams..is it not enough?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply