BDPDataAdapter MaxRecords

[Robin]

Hey all,

I have just noticed the MaxRecords property of a BDPDataAdapter.

As its default is set to 100, I have been missing out on the rest of the
results.

Now, the help does not say much about it except the exceedingly obvious,
but my tests seem to indicate that setting it to 0 retrieves all rows.

Can anyone confirm this? I would rather not set it to 99999999999999 if
I can avoid it.

I must say, setting a limited number as the default seems rediculous to
me. Surely it should return everything as default, and have the option
to limit results if desired (for paging or something). Not the other
way around.

TIA.

--
Robin.

Australian Bridal Accessories := http://www.bridalbuzz.com.au
Turbo for Noobs (a work in progress) := http://turbofornoobs.blogspot.com/

[john]

"Robin" <Robin@.com> wrote in message
news:4603...@newsgroups.borland.com...

> Hey all,
>
> I have just noticed the MaxRecords property of a BDPDataAdapter.
>
> As its default is set to 100, I have been missing out on the rest of the
> results.

Same here, only it was a while ago for me. As I recall I tested it and the
default value of 100 wasn't being honored... it will fill more then 100
records. It doesnt limit you. I notice that if you leave the default value
there is no assignment to MaxRecords generated in InitializeComponent(). So
I just left it alone.

[john]

hmm looks like filling via the .Active property does honor MaxRecords.

"john" <som...@no.no> wrote in message
news:46042b49$1...@newsgroups.borland.com...