Hi Atif!

I'm not sure if this works but it seems to me that the data in the cursoradapter and the database are different and therefore you get this message.

If got a similar message when working with SQL-Views - I had to REQUERY the view.
For a CursorAdapter the help lists the following method and description:

CursorRefresh Method
Applies To: CursorAdapter Class
Refreshes a cursor with current data from the data source. CursorRefresh re-executes the value of the SelectCmd parameter in the BeforeCursorRefresh event with respect to CursorAdapter DataSourceType.
...

HTH


>HI all!
>
>i am facing a prob while deleting a record from sql server. i'll explain in detail with example.
>lets see i have one record in master table and the related record is in the different child tables in database. from the sql database u can not delete the parent record as it has refrentional integrity or relationship as primary and foreign key.
>now when i am trying to delete this record from the front end screen, from a parent system is giving me a message as it should give but the same time when i am trying to do any other function with this table system is not allowing me to do this as it is showing me the following error message.
>THE MESSAGE IS : Row handle referred to a deleted row or a row marked for deletion.
>tell me how to get rid of this problem.
>i am using cursor adaptor for all this updation purposes i have used tableupdate method for this and as it is not allowing to delete the record i am then using TABLEREVERT AND rollback transaction and same time showing error message with the ON ERROR routine.
>
>thanks in advance.
>atif saeed khan
>software engineer
>real time technology
>uae, dubai.