Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Error when saving!
Message
General information
Forum:
ASP.NET
Category:
The Mere Mortals .NET Framework
Miscellaneous
Thread ID:
01161662
Message ID:
01161882
Views:
15
>
>It gives an error below:
>
>Dynamic SQL generation is not supported against multiple base tables.
>
>BTW, the error is pointing to the this.oPsDatacenter.SaveDataSet() command.
>
>I use mmUltraButtonNew and mmUltraButtonSave but it gives me the same error but this time code looks like below:
>

Does your initial query in the business object join two tables together? If so, that's the problem.

ADO.NET tries to dynamically generate the SQL statement to do an update and will fail if the initial source is made up of two (or more) tables. To get around this, follow the instructions in the docs to create a custom data access class (Data Access with Business Objects > Creating Custom Data Access Classes). This will force it to use the generated INSERT/UPDATE/DELETE that was created from this step instead of trying to dynamically build it.
-Paul

RCS Solutions, Inc.
Blog
Twitter
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform