Sergio,

You've put a quote around your numeric field, as if it were a character field. Remove that and it should be fine.

string strUpdateSelect  = "UPDATE policy SET wsc001 = " + nBPC +"   "+
	                "WHERE policy.controlnum ==  '"+ controlNumber +"' ";

~~Bonnie



>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