V4WS need to use semaphores when READ from table in case cause simultaneous indexing?

[Ruslan Zasukhin]

On 11/28/04 6:15 AM, "Steven" <srt at bigpond.net.au> wrote:

> Ruslan,
> 
>> In the Db.SqlSelect() you should see 3 new parameters to control HOW
>> Valentina lock records of a new cursor. Please check docs.
>> 
> 
> EXAMPLE CODE:
> 
> CursorRef = valSqlSelect( dbGuestBookRef,
> "SELECT FirstName, LastName FROM Person
> WHERE FirstName < ŒK¹ ORDER BY "FirstName", kClient, kReadWrite);
> 
> if ( valIsValidCursor( CursorRef )=true ) then
> //successfully locked all records
> else
> //could not lock all records
> end if;
> 
> Is this the best/only way to test if the cursor was successful in
> locking the records in V4WS?

I recommend to use not valIsValidCursor() but error code check

CursorRef = valSqlSelect( dbGuestBookRef, ".........


if ( valLastError(dbRef) != 0 ) then

    we have problems....

End if


-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------