Hi guys!

Im trying to use a SQLPassthrough command on updating a table. The problem is very unusuall. I hope you can help me with this one. The code is provided below. Please check if I had omitted something.


Thanks in advance...

lparameters cDesc, cItemid, cPrice

nHandle = sqlconnect("DSN Name")
cSQL = [Update Accounting!items Set Desc = ] + ["] + alltrim(cDesc) + [",] +;
[Price = ] + alltrim(str(cPrice)) +;
[ Where itemid = ] + ["] + alltrim(cItemid)+ ["]