hog Posted June 2, 2003 Posted June 2, 2003 Until recently my datasets only referenced a single table and all my code worked fine. But to aid the production of useful reports I ended up modifying my datasets to include multiple tables, which all seem OK. The problem I have just discovered now is that all my code that previously works using the dataset method GetUpdateCommand now produces this error: Dynamic SQL generation is not supported against multiple tables Am I correct in assuming that I'm goning to have to create the update sql manually and use .ExecuteNonQuery? Quote My website
*Experts* jfackler Posted June 2, 2003 *Experts* Posted June 2, 2003 The command builder only works for single tables with a primary key. Yes you will need to write the update manually. Jon Quote
hog Posted June 2, 2003 Author Posted June 2, 2003 This is a big problem now! If I use manual sql I loose the optimistic concurrency! Any ideas on how to implement this manually? The way things were prior to changing the datasets ensured no data clashes!! Quote My website
hog Posted November 11, 2003 Author Posted November 11, 2003 I obviously forgot about this and have now got caught out by it again:( Does anyone know how to solve this problem? Quote My website
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.