Hey Doug,

I have this original code that has an error:

cSQL = [UPDATE ACCOUNTING!ITEMS SET desc = "] + ALLTRIM(cDesc) + ["] + [,] +;
[ saleprice = ] + STR(nPrice) + [,] +;
[ WHERE itemid = "] + Alltrim(cItemid) + ["]

the desc field is the reserved word. Are you suggesting that I change it to the following code below?


cSQL = [UPDATE ACCOUNTING!ITEMS SET 'desc'= "] + ALLTRIM(cDesc)+ ["] + [,] +;
[ saleprice = ] + STR(nPrice) + [,] +;
[ WHERE itemid = "] + Alltrim(cItemid) + ["]

the 2nd set code does not work and produces the same error message..
Please clarify what you mean...