>Hi,
>
>I use CursorAdapters for inserting/updating/delete data in SQL Server. I have a base class that all tables use. The problem is when I try to delete a record in one of the tables it does not work. I get no error and when I step through the code in debugger everything seem to be normal. But the record in SQL Server never gets deleted. I have checked the code in the CursorAdapter class, method BeforeDelete and it correctly has expression:
>
>delete from TableName where Pk_Fld = ?oldval('Pk_fld','CaViewName')
>
>
>I also checked in the same method that the value of oldVal('pk_fld') is the one I am trying to delete.
>
>When I delete a record from another table (using the same base class), it works.
>
>Where should I look for? In SQL Server? or in my VFP code? TIA.
I'd start from firing a SQL Server profiler and looking at the command that is getting executed. Then I would also check if there are any triggers on that table.
If it's not broken, fix it until it is.
My Blog