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:
01161952
Views:
14
>>
>>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.

So you mean, I will be creating a custom data access business object for all tables? That if I have 200 tables in one database, I will be creating 200 custom DAs? If that so, then all the custom DAs I added in the dynamically created business objects through MM.Net will be dumped.
JESS S. BANAGA
Project Leader - SDD division
...shifting from VFP to C#.Net

CHARISMA simply means: "Be more concerned about making others feel good about themselves than you are in making them feel good about you."
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform