How to avoid requerying an ADO recordset

[rodica]

I'm sure this is easy for you, gurus.
I'm designing a multiuser application using Oracle table. I want to see the other user changes without requerying the whole recordset. I will appreciate if I can get some sample codes.

Thank you

[Lafor]

connect to oracle using ADO
get your data from table
then disconnect the recordset by setting active connection
to nothing...

make your changes to recordset
then use .resync property of recordset..

[rodica]

Why I need to disconnect the recordset?
Before resync-ing the recordset do I need to open the connection again?

[sanon]

Yes, you have to reconnect again when you requery the recordset. The reason that Lafor disconnect in the first place because he didn't want to block other users to use that table.

Anyway, Rodica, in your question, you said you wanted to see other users change without requery the whole recordset. Is that mean you want to see only the updated records or you don't care about the updated records?

[rodica]

I want to see all records including the ones updated by the other users.
Do you have handy any code available?