UPDATE statement on MDB failes

the UPDATE statement with the OleDbCommand class wont work with me :(
i cant seem to get it right

i use for an example the following statement:

'update tbl_DynCountry set Country = @Country where CountryID = @CountryID'

then i add the parameters, and i add the database connection to the command!

when i am in debugmode, everything seems ok, dataconnection is open,
parameters are attached, with the right value,
then i use the method

command.ExecuteNonQuery();

and the return value is 0 -- meaning 0 rows affected!

i cant seem to find the problem :(

insert statements are working fine, but the update aint :(

did anybody have the same problem in the past??? and how do i solve it?




.

Relevant Pages

  • UPDATE statement on an MDB
    ... the UPDATE statement with the OleDbCommand class wont work with me:( ... i cant seem to find the problem:( ...
    (microsoft.public.data.oledb)
  • UPDATE statement doesnt work
    ... the UPDATE statement with the OleDbCommand class wont work with me:( ... i cant seem to find the problem:( ...
    (microsoft.public.data.odbc)
  • Re: Upload a file question
    ... pdf column and he cant find the old one! ... it in the UPDATE statement and i cant.. ... Build your update statement dynamically. ... $sql = "UPDATE relatorio SET ...
    (comp.lang.php)
  • Re: Upload a file question
    ... How can i protect the forms in PHP? ... it in the UPDATE statement and i cant.. ... Build your update statement dynamically. ...
    (comp.lang.php)