V4REV 2.4 and VServer - SQLSelect

[Ruslan Zasukhin]

On 8/8/06 1:53 PM, "Dave Cragg" <dcragg at lacscentre.co.uk> wrote:

> Situation 2
> 
> Using vDatabase_SQLSelect and then looping through the cursor to
> retrieve field values, I get no crash. But the field values start to
> repeat after looping through  774 records. The returned data looks
> something like this:
> 
> test0001 Jones Sue
> test0002 Smith Joe
> ---<snipped>---
> test0772 Pyjobat Muz
> test0773 Kygoguh Nafar
> test0774 Kopohor Wezen
> test0775 Visab 
> test0775 Visab 
> test0775 Visab 
> test0775 Visab 
> test0775 Visab
> ---<snipped>---
> 
> The data in the database seems fine. For example, if I use (select *
> from users limit 773,5) I get the following:
> 
> test0774 Kopohor Wezen
> test0775 Visab Goh
> test0776 Miw Rab
> test0777 Nid Hedel
> test0778 Sasyjer Dedud
> 
> I see a similar problem when using VStudio. But in this case the
> repetition starts after about 460 records.
> 
> I notice that the repetion with the Rev client starts after about 16K
> of data. (Is this significant?)

We do not have any such limits as 8 or 16 Rb

What cursor you use in both cases?
    Server side or client side ?

Also please send me your database off list.
And cc to Kirill. 


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