Did you put double qoutes around the command and single qoutes around the value?
>>>The following commands in a VFP program should delete from an sql database all records for the appropriate accountno but nothing happens
>>>
>>>
>>> lcsqlcommand ="delete JobList where TRIM(accountno)=DG34214"
>>> lnresult = SQLEXEC(gnConnHandle,lcsqlcommand)
>>> select sqlresult
>>>
>>>What have I done wrong?
>>
>>For starts Colin if you ran that command in SQL it would not work. You need quotes round the string.
>>
>>"delete JobList where TRIM(accountno)='DG34214'"
>
>If I put quotes around the string I get a compile error
Gerhard Schmidbauer
URANUS Software GmbH