>
>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.