[V4RB] Multiple cursors on one database

[Ruslan Zasukhin]

On 7/8/06 8:29 PM, "Bill Mounce" <billmounce at comcast.net> wrote:

Hi Bill.

> I am continuing to have trouble with opening multiple cursors on the
> same database, as I see others are from the notes on this mailing list.
> 
> 1. I start opening one cursor as read/write:
> 
>      curOne = mInflected.SQLselect("select * from INFLECTED",
> EVCursorLocation.kServerSide, EVLockType.kReadWrite,
> EVCursorDirection.kRandom )
> 
> 2. Then later in the code I want to open a second cursor as readonly:
> 
>    curTwo = mInflected.SQLselect( "select * from INFLECTED",
> EVCursorLocation.kServerSide, EVLockType.kReadOnly,
> EVCursorDirection.kForwardOnly )

You CANNOT DO this !!!

You already have lock records by first cursor as READ WRITE,
READ WRITE also have other name EXCLUSIVE.

Nobody else cannot even read these records.
 
> Should I not be able to do this? The second cursor is for lookup
> only, and any changes I might make to curOne don't affect my lookups
> in curTwo.
> 
> If I comment out curOne, curTwo works, so I can only assume that
> these two cursors are incompatible. This is a single-user application.
> 
> This happens in my application over and over. Is my assumption above
> correct? Should I be able to open both cursors?

-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]