It could be that you are trying to delete a parent record that has children records associated and the trigger is preventing you from doing it.
You can send the same SQL Statement from SQL Query Analyzer and see if you get more information there (probably no, but it might be worth a try.)
You can also use SQL Profiler to see exactly what SQL Server is receiving from VFP. That will probably give you some hints.
Lastly, you can modify the DELETE trigger on you table to display debug values an see if you can find out what's the problem.
>Anyone have a quick way to locate the problem when getting a 1526 error 'Trigger
>Failed' when issues a sqlexec('delete from
where ???)
>
>Ronnie
Hector Correa