Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post Sep 07, 2011 06:45 PM by chohmann
Sep 07, 2011 05:48 PM|LINK
I created a dataset with 3 tables
I would like to run updates on all 3 tables
Is it possible to have 3 different update commands (1 for each table) held by the data adaptor simultaneuously?
dataAdaptor.updatecommand = uc1;
dataAdaptor.updatecommand = uc2;
dataAdaptor.updatecommand = uc3;
I immagine in the above example uc3 is the only update command in the dataadaptor
you can batch sql queries ie.
sql = "selelct * from table1;select * from table2;select * from table3;";
to create the dataset. Is there some kind of concatenated update statement?
In my situation I go through each table seperately and make modification visa vi
update record here
when all is said and done inserts, updates, deletes for all the different tables
I want to execute 1 dataadaptor.update
I am trying to avoid having to do a complicated join for the update commands.
any help here would be appreciated
Sep 07, 2011 06:45 PM|LINK
No, DataAdapters can only update one table. Here's a link: