--- In IBDI@y..., "Ann W. Harrison" <aharrison@i...> wrote:

> At 05:59 PM 6/15/2001 +0000, Alexander V.Nevsky wrote:
>
> He stored 20,000 records, each consisting of one
> long word which started at 0 and went to 19999.
>
>
> >SHOW GENERATOR testgen
> >Generator TESTGEN, Next value: 0
> >
> >And from D5/IBX application using TIBQuery:
> >Select Gen_Id(testgen, 1), Code from Test
> >where Code<10000
> >
> >SHOW GENERATOR testgen
> >Generator TESTGEN, Next value: 4680
>
> Hunh? You stored 10.000 records and got
> back 4680? Or did IBX send you the first
> bunch and hold back on the rest, waiting
> for you to do something?
>

Hi, Ann. I stored 20 000 records without touch generator. Then I
made select of 10 000 firing generator on select each record. I made
it via component not linked to db-aware controls and waited 1 record
to be fetched and generator to be fired 1 time. I supposed records are
visited from access bitmap only when fetch is requested. But I see
neither 1 increment nor 10 000 what should be if all records to be
fetched are visited before fetch. Sorry for my English.