-
Nov 10th, 2000, 01:35 PM
#1
Thread Starter
Junior Member
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
-
Nov 10th, 2000, 03:59 PM
#2
Fanatic Member
ADO and disconnected recordsets
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..
-
Nov 10th, 2000, 04:35 PM
#3
Thread Starter
Junior Member
Why I need to disconnect the recordset?
Before resync-ing the recordset do I need to open the connection again?
-
Nov 10th, 2000, 11:26 PM
#4
Lively Member
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?
-
Nov 14th, 2000, 12:20 PM
#5
Thread Starter
Junior Member
I want to see all records
I want to see all records including the ones updated by the other users.
Do you have handy any code available?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|