dynamic sql generation is not supported against multiple base tables errors.

J

jaYPee

I try to modify the "VB.NET - Data Access - Build a Master-Detail
Windows Form" sample to update the record but i get this error
dynamic sql generation is not supported against multiple base tables

anyone know how to update the record from this sample app?
 
P

power_mj

I think you can use relationShip of sql server.If you
build relationship in your database you can modefy parent
table directly and then child table can modefy automatic.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dynamic SQL generation is not supported against a SelectCommand that does not return any base table 2
implement a Join between 2 DataTables (Dynamic SQL generation is not supported against multiple base 4
Dynamic SQL generation for the UpdateCommand is not supported ... 5
Writing Update Back to SQL Server 2
Help with Error - ( UPDATE DataTable ) does not make sense to me. 1
Dynamic SQL generation is not supported against a SelectCommand ... 2
Dynamic SQL generation - How do I set the key column information manually? 2
Dynamic SQL generation for the UpdateCommand 2

Top