Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Exception occurs when saving record
Message
Information générale
Forum:
ASP.NET
Catégorie:
The Mere Mortals .NET Framework
Divers
Thread ID:
01140611
Message ID:
01141005
Vues:
21
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?
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform