Re: Why does cachesize > 1 skip records?? Bug??


<gwhite1@xxxxxxxxx> wrote in message
news:1178197313.326128.193370@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
I have a simple open and read code:

SQL$ = "SELECT I.IMS, d.ZIP, TERRS, SOURCE From rx_uf"
ads.CacheSize = 100
ads.Open SQL$, adb, adOpenForwardOnly, adLockOptimistic
'do stuff
ads.movenext

But this code skips records.

Then something is wrong.
It should not skip records.
Are you _CERTAIN_ that the code in 'do stuff is not affecting what is
considered the current record?

This code fragement does not indicate whether it is server-sided or
client-sided, but I assume it is server-sided if you have not changed the
connections CursorLocation.

When I change the cachesize to 1 it does
not skip records. Why would the cachesize > 1 skip records?

Because maybe something you are doing in 'dostuff is changing things.
Your not inserting or deleting records?
Changing the primary key?

Is there a bug or something else I need to do to make it not skip records.

Let us know what dostuff contains - who knows you could be interfering with
the current record.

Stephen Howe



.