Add data into 2 tables

[Guest_imported]

Do you have any idea on how to add data onto 2 different tables.s-)

 

[KodoSan]

if you want to do it at the same time then you may want to research cascading updates.

 

[hblackorby]

Cascading updates only work when one field is a foriegn key in another field. While this is nice, it only works on those related fields. If you are just looking to update two tables, just create two different SQL statements and run them right after each other using Conn.Execute. Trying to get them to run at the same time can be dangerous if the second SQL table is in any affected by the first (except with foriegn key relationships). Harold Blackorby
hblackorby@scoreinteractive.com
St. Louis, MO

 

[hblackorby]

Cascading updates only work when one field is a foriegn key in another field. While this is nice, it only works on those related fields. If you are just looking to update two tables, just create two different SQL statements and run them right after each other using Conn.Execute. Trying to get them to run at the same time can be dangerous if the second SQL table is in any way affected by the first (except with foriegn key relationships). Harold Blackorby
hblackorby@scoreinteractive.com
St. Louis, MO

 

[vasah20]

The best way to do it: Stored Procedures. leo

------------
Leo Mendoza
lmendoza@students.depaul.edu