DataAdapter set up for delete/update error

chime

Member
Joined
Jul 12, 2005
Messages
22
Location
wexford, Ireland
Programming Experience
3-5
Hi

When I am using the wizard to configure a dataAdapter it works fine for the SELECT and INSERT sections.
But it gives an error for the UPDATE and DELETE sections.
I have tried it on different tables of the MySQL Database all of which have a primary key.
I am also using the simplest SELECT statement - SELECT * FROM tablename

Would anyone have an idea what the problem is.

Thanks
 

DavidT_macktool

Well-known member
Joined
Oct 21, 2004
Messages
502
Location
Indiana
Programming Experience
3-5
Select each field

Try selecting each field individually. Provid a more accurate description of the errors displayed on the screen that shows the sql statements generated.

Also try hitting the advanced options button and unchecking 'Use Optimistic Concurrency' and 'Refresh Dataset' options.

Hope this will provide clues to the problem.
 

chime

Member
Joined
Jul 12, 2005
Messages
22
Location
wexford, Ireland
Programming Experience
3-5
I have Tried selecting each field individually and have unchecked 'Use Optimistic Concurrency' ('Refresh Dataset' is greyed out)
the error is the same

I have attached the error section
I am configuring the dataadapter by right ckicking on it and going through the steps
Its just the last step which shows the error
It works fine for the SELECT statements
I have primary keys on the first column of the database
 

Attachments

  • Doc1.doc
    34 KB · Views: 35

DavidT_macktool

Well-known member
Joined
Oct 21, 2004
Messages
502
Location
Indiana
Programming Experience
3-5
What Database are you using?

What database are you using?

Have you tried using OleDbDataAdapter or SqlDataAdapters?

Have you tried using the DataForm wizard to create the Adapters and Sql statements for you?

One of these things might get you going in the right direction, the dataform wizard is a good learning tool to see the statements generated and get familiar with the syntax.
 
Top Bottom