TEXT TO lcSQL TEXTMERGE NOSHOW PRETEXT 7 UPDATE icitem SET carloc = ?m.carloc WHERE item = '<<lc_item>>' ENDTEXT lnRetVal = SQLEXEC(ln_connection, lcSQL)>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) >>