Question about Deleting from a table

[Mahopacs]

I have a recordset that contains all entries from a table (i.e. Select * from....) I have a stored procedure that deletes from the table..

After I execute this delete stored procedure I need my recordset to reflect this BUT ALSO TO MAINTAIN it's current position in the recordset....(I.E. So I can't just re-execute the recordset, as this will set the pointer to the
begginning of the recoredset)

Is there a way to do this?

I've tried refresh and this does not seem to work

Thanks!

Ted

 

[carp]

What RDBMS are you using?
What form does your recordset have (i.e., cursor, table, etc).
Are you using a script, a PL/SQL routine, or something else?

In order to provide answers to your question, you need to provide full information about your situation.