Syntax error (missing operator) when deleting a row with commandbu

Hi I hope someone can help

I am creating a C# project that stores data into an Access database.

I have created a dataset using an OleDbDataAdapter with a sql select statment
"SELECT table.* FROM table

This table has a long Interger autonumbering ID key field, 1 text field, 1
Long Interger field, and 31 Double fields.

I then use the Commandbuilder object to create the Insert, delete and update
commands.

The Insert command seems to work ok as I can create a new row and use the
OleDbDataAdapter.update( ); with now problems

My problem is that I get Syntax error (missing operator) when I attempt to
update a record set after deleting a row.

After this I introduced a dataGrid control and connected this to the dataset
and all the data seems to be ok.

I have other tables in my project that a treated in a similar mannor and
these seem to delete rows ok. The only thing is that these other tables have
less fields but thats the only differance that I can see.

Any ideas?
--
All the best
Hawkmoth
.

Relevant Pages
Loading