V4RB -- 2 cursors on same data

[Ruslan Zasukhin]

On 5/30/05 8:57 PM, "Claudius Sailer" <Claudius at sailer-online.de> wrote:

> Hi,
> 
> Am 30. Mai 2005 um 18:34 Uhr schrieb Ruslan Zasukhin:
> 
>>> 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
>> 
> 
> I use
> 
> DB.SQLSelect(SQLString, EVCursorLocation.kServerSide,
> EVLockType.kNoLocks, EVCursorDirection.kRandom)
> 
> is it better to modify this? Using other parameters?
> I never make updates in Cursor. Is it faster to use kReadOnly?

Yes NoLocks is faster because it not spend time to set 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]