>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
ParCmd.CommandText = "UPDATE WPPAR SET PAR_NUM = ? where PAR_PK = 1";
and you don't need to convert an int to a string (would error if that is numeric on VFP):
ParCmd.Parameters.AddWithValue("@PAR_NUM", intNumber);
ParCmd.CommandText = "UPDATE WPPAR SET PAR_NUM = ? where PAR_PK = 1";
Cetin