V4RB -- 2 cursors on same data

[Ruslan Zasukhin]

On 5/30/05 5:51 PM, "Bill Mounce" <billmounce at comcast.net> wrote:

Hi Bill,

> It is my understanding that if I have created one cursor that is
> read/write drawing from all the data in the database, and then try to
> create a second cursor that is read only on some of those records, that
> Valentina does not allow this because of record locking. Is this true?

yes

> I would think that if the second is read only it shouldn't matter.

It matters, because first cursor can WRITE,
So you can get problems.

    e.g. You read some record with cursor2
    go to next, return back, but OPS, its is changed

 
> Currently what is happening is that the SQL call used to create the
> second cursor always fails unless I nil the first cursor.

You can use for first cursor NO LOCKS


-- 
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]