>>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
Specialist in Advertising, Marketing, especially Direct Marketing
I run courses in Business Management and Marketing