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.