problem with UPDATE and CONNECTION.ExecuteNonQuery

  • Thread starter Thread starter Franky
  • Start date Start date
F

Franky

I have a function to update the data of the BD, all ok , insert,
delete,load,etc, but if the instruction is UPDATE the connection fail . the
message of error is:
"The command text contained one or more errors"
the sql is correct, in access accept the sql and update the data.. but in
the command not.
the update is in a PPC whith BD .cdb

Why???
 
Can you post the CommandText? Also, are you paramaterizing the query? If
not, you may have a value in there with an apostrophe or some other value
like that which is causing hte problem. Finally, check the column names to
make sure their valid and not reserved words - if they are, stick them in []
 
If this is for a Pocket Access database - .cdb then the UPDATE sql statement
isn't supported. The only way to update existing records with Pocket Access
is to use the Recordset class or a wrapper around it to navigate to the
specific row, set the new values and call update on the recordset.

Peter
 
Back
Top