>>>this is my code
>>>
>>>TEXT TO lcsqlcommand NOSHOW
>>>delete JobList where accountno='DG34214'
>>>ENDTEXT
>>
>>This should work fine. Did you try running the select statement in SQL Server, e.g.
>>

>>select * from JobList where accountno='DG34214'

>
>No I am running it from a VFP program

Do you have access to SQL Server to try it directly there? If not, can you still try running select statement first to verify if you get rows?