cursor and V4md client problem

[Gregory Kowalski]

On Apr 27, 2004, at 1:37 AM, valentina-request at lists.macserve.net wrote:

>>>>>> Hello,
>>>>>>
>>>>>> I have encountered a cursor navigation problem when passing from 
>>>>>> V4MD to
>>>>>> V4MD Client.  I have the project set up so that the query results 
>>>>>> appear
>>>>>> in a table ten at a time.  There are navigation buttons for NEXT 
>>>>>> 10 and
>>>>>> PREVIOUS 10.
>>>>>>
>>>>>> The project was developed with V4MD and worked great.  Then I 
>>>>>> tested it
>>>>>> with V4MD Client and found that when navigating backwards 
>>>>>> (previous 10)
>>>>>> everything falls out of line (moving forward everything is fine). 
>>>>>>  I
>>>>>> should add that I didn't touch any of the cursor code.
>>>>>>
>>>>>> Any help would be appreciated.
>>>>>>
>>>>> Hi Gregory,
>>>>>
>>>>> I think you need simply add to cursor creation parameter
>>>>>
>>>>> Random
>>>>>
>>>>> On default Valentina make ForwardOnly cursor.
>>>>>
>>>>> Check docs of VCursor
>>>>
>>>> The cursor parameter is set to random.  As I said, it works 
>>>> perfectly
>>>> with V4MD.  When switching to V4MD_Client no cursor code was changed
>>>> yet it does not behave the same way.
>>>
>>> V4MD actually ignore all that parameters!!!
>>> So this is not a reason.
>>>
>>> Okay, show how you create cursor? Your line of code?
>>
>>
>> My code for the cursor is:
>>
>> gMyCursor = new( xtra "VCursor", GetRef(gMyDB), whichSearch, 1, 2, 2)
>
> I.e.
>
>         kClient, kReadOnly, kRandom
>
> Looks to be correct.
>
> Just in case try kServerSide cursor,
>
>         2, 2, 2
>

I just tried it with 2,2,2 - it doesn't work either and it is MUCH 
slower.

Greg