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...
Music Rocks
www.musicreserve.blogspot.comSuccess is 1% Inspiration & 99% Perspiration
God Sometimes Delays His Help to Test Our Faith and Energize Our Prayers
Our Boat May Be Tossed While He Sleeps, But He Wakes Up Before it Sinks.