Hi.
I have following command and am getting a Syntax Error on execution
I tried with Int and Int.Tosting but both give the error
(PAR_NUM is a n(10,0) FIELD IN A vfp TABLE

// ParCmd.Parameters.AddWithValue("@PAR_NUM", intNumber);
ParCmd.Parameters.AddWithValue("@PAR_NUM", intNumber.ToString().Trim());

ParCmd.CommandText = "UPDATE WPPAR SET PAR_NUM = @PAR_NUM where PAR_PK = 1";
ParCmd.ExecuteNonQuery();
Any help appreciated
Regards,
Gerard