>I am having a problem with the following code:
>
>

>m.carloc = ThisForm.carousel + ;
>           PADL(LTRIM(STR(ThisForm.bin, 2, 0)), 2, "0") + ;
>           PADL(LTRIM(STR(ThisForm.shelf, 2, 0)), 2, "0") + ;
>           ThisForm.loc
>
>lc_update = [carloc = ?m.carloc]
>lc_item   = ThisForm.citem
>
>*-- Update ICITEM table  	
>lcSQL = [UPDATE icitem SET ] + lc_update + [ WHERE item = ] + lc_item
>lnRetVal = SQLEXEC(ln_connection, lcSQL)
>

>
>m.carloc is a character type variable and the carloc field in icitem is set as a character field. When the update is attempted AERROR() says that the problem is "Error converting data type varchar to numeric."
>
>I don't understand why any conversion would be necessary and why numberic?
>
>Thank you

Check ThisForm.citem