How to Keep RDO Cursor Open After Transaction!

[VenkatY]

Hi,

I have a problem after i use CommitTrans on the RDOConnection. If i refer the Resultset again it is giving an error:
Run-time error '40088':
No open cursor or cursor closed

I have tried to use SQLSetConnectOption API as per the MSDN support article on"HowTo: Keep RDO Cursor open after transaction"

I am connecting to ORacle 8i database from VB6.0

Any help is greatly appreciated?


thanks

 

[vb5prgrmr]

Create two connection objects, one for the recordset and one for the update/insert query you are running.

Good Luck

 

[LazyMe]

That should work, but might lead to locking problems, since you're working on two separate connections.
Greetings,
Rick

 

[vb5prgrmr]

LazyMe,

Two things to note:

1. Vb is single threaded so unless VenKatY is doing this update/insert asynchronously (which I doubt because of CommitTrans is being used and catching errors)

2. CommitTrans Is being used

 

[LazyMe]

Yes, I know. I only meant he should take into account this when defining the recordset he's working with. Although it's just one thread, the recordset, if not appropiately used, could lock the table/row he's trying to update. Even though VB is just one thread, two connections always can collide with one another, even if one is "not being used" at the moment.
Greetings,
Rick