NODBC Update Command

HaroldVanAarsen

Hello Reader,

I am trying to update a field in table 39 (Purchase Line) with ODBCCommand, but the field value does not get updated.
What am I doing wrong?

Code :
string updateCommand = "UPDATE /"Purchase Line/" " +
"SET \"Description 2\" = '" + InkoopGeboekt.Ontvangen_aantal + "' " +
"WHERE \"Document No_\" = '" + InkoopGeboekt.Documentnr + "' " +
"AND \"Line No_\" = " + InkoopGeboekt.Regelnr + " " +
"AND \"No_\" = '" + InkoopGeboekt.Nr + "' ";

OdbcCommand DbCommand = new OdbcCommand(updateCommand, DbConnection);
int iRows = DbCommand.ExecuteNonQuery();

It tells me 1 row is affected, but it is not changed in Navision.

I am using NODBC on Navision 2009 R2
I am programming in Visual Studio 2012 with Dotnet 4.0

wkr,

Harold van Aarsen