Hi,
I'm setting up lookup screens on forms and I'd like to limit the number of records retrieved, and have a "More..." button to retrieve the next group, etc. The fields and operators searched on are selected from combo boxes. The first batch of records I'm limiting with a TOP clause.

I'm trying to rotate the next sets of records thru the dataset with the fill command that limits the number of records retrieved. The protected fill method with the signature
(Dataset, integer, integer, string, ldbcommand, commandbehavior) would be useful, but apparently is not accessible, since it's in an abstract class only.

I'm sure limiting the number of records retrieved is a common problem in client server, so can someone give me an example of how to bring records down in chunks, or tell me how to use the above fill method?

TIA.