David,
>When creating a custom data access class for an oleDbData Adapter, I get errors configuring the data adapter when generating the SQL UPDATE and Delete statements. The SELECT, INSERT and table mappings do not generate an error.
>
>Basically I followed the example in the JumpStart Guide for Creating Business Objects - C# Step 6, except when creating the custom class I choose the 'oleDBDataAdapter' instead of the 'SQLDataAdapter'. I was able to select all of the columns and click the OK button to close the query builder. It was on the 'View Wizard Results' screen where the errors were detailed. Looking at the code that is generated, the UPDATE and DELETE sections are not there.
>
>I also looked at the Northwind sample for the OrderdetailDataAccessOledb.cs file and saw that an UPDATE and DELETE section was created.
Depending on the database you are using on your back end there are various "issues" with the Visual Studio Data Adapter wizard. What data are you trying to access?
Regards,
Kevin McNeish
Eight-Time .NET MVP
VFP and iOS Author, Speaker & Trainer
Oak Leaf Enterprises, Inc.
Chief Architect, MM Framework
http://www.oakleafsd.com