>Hi All,
>
>I m using cursor adapter in forms , i m able to insert, update from cursor adapter but while deleting from cursoradapter the record gets deleted from cursoradapter but cannot delete from SQL table.
>Please suggest any help.
>
>
>thanks.

Check for Error after TableUpdate()

IF NOT TABLEUPDATE(.....)
   AERROR(aaa)
   MessageBox(aaa[1,2])
ENDIF

It looks like some trigger is fired that does not allow you to delete some records.