cursors

[Ruslan Zasukhin]

On 8/30/05 8:36 AM, "jacques perconte" <trash at technart.net> wrote:

> Hello all,
> 
> I¹m new in here, in the director xtra...
> 
> I¹m working with valentina for two weeks only, and I have some problems with
> cursors, maybe technical ones or conceptual onesŠ
> 
> Global curs, ccurs
> 
> on Qall bank
>   query = "SELECT * from " & bank
>   queen query, bank
> end
> 
> on queen query, bank
>   kServer = 2
>   kReadWrite = 3 
> 
>     curs = 0
>     curs = new(xtra "VCursor", GetRef(gMb), query, kServer, kReadWrite)
>     ccurs = GetRecordCount(curs)
> end
> 

> if I use it once, everything is ok, but as soon I try to use it another time
> I get error messages.
> 
> error 363
> error 5

363 - this is record lock error.

This means that first cursor have lock records as ReadWrite,
And second cursor try to access them
 
If you do not care about locks, you can use kNoLocks

> Maybe I do not have to declare more that one "new" Vcursor...
> I do not find how to renew/change the sql query in the cursor.
> If you could help me please, it's quiet urgent It's always ;)




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