Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Exception occurs when saving record
Message
General information
Forum:
ASP.NET
Category:
The Mere Mortals .NET Framework
Miscellaneous
Thread ID:
01140611
Message ID:
01141005
Views:
15
Hi Kevin,

This time I got another error message when try to update the record using business object. I select the record from more than one table and load the record into the page.
When the save() function as below is called, the error occurs.
If Me.Save(Me.oVxlve, dsVxlve, Me.oVxlve.TableName) = mmSaveDataResult.RulesPassed Then
     Response.Redirect("ViewRecords.aspx")
End If
The error message as below:
Dynamic SQL generation is not supported against multiple base tables. 
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. 

Exception Details: System.InvalidOperationException: Dynamic SQL generation is not supported against multiple base tables.

Source Error: 


Line 103:
Line 104:        'ConvertData()
Line 105:        If Me.Save(Me.oVxlve, dsVxlve, Me.oVxlve.TableName) = mmSaveDataResult.RulesPassed Then
Line 106:            Response.Redirect("LveRecords.aspx")
Line 107:        End If
What is the cause of this error?
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform