Hello everyone,

I am trying to update a field in a vfp table buy I get the following error :

Data Type mismatch

The visual foxpro field called wsc001 is numeric(numeric,10,0) type.

Here is the c# code:

int nBPC = 4;
string strUpdateSelect  = "UPDATE policy SET wsc001 = '" + nBPC +" '   "+
	                "WHERE policy.controlnum ==  '"+ controlNumber +"' ";
		
//*-- Create a command object with the update select
OleDbCommand  VFP7UpdateCommand = new OleDbCommandstrUpdateSelect,VFPConnection);
// Execute the command
VFP7UpdateCommand.ExecuteNonQuery();
//Close the connection
VFPConnection.Close();

I think the problem is with the string strUpdateSelect.
The update will work if I update a vfp character field, but I can not get it to work for a numeric field.

Any help is appreciated.

Thanks,
Sergio