BDPDataAdapter MaxRecords

Thread View: borland.public.delphi.database.bdp

3 messages

[T] Back to Threads [V] Tree View [G] Group Articles

3 total messages Started by Robin Fri, 23 Mar 2007 03:28

#213

Author: Robin
Date: Fri, 23 Mar 2007 03:28

25 lines
1624 bytes

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/

Re: BDPDataAdapter MaxRecords

#214

Author: john
Date: Fri, 23 Mar 2007 19:32

14 lines
1579 bytes

"Robin" <Robin@.com> wrote in message 
news:46034942@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.

Re: BDPDataAdapter MaxRecords

#226

Author: john
Date: Tue, 03 Apr 2007 17:23

20 lines
1629 bytes

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


"john" <someone@no.no> wrote in message 
news:46042b49$1@newsgroups.borland.com...
> "Robin" <Robin@.com> wrote in message 
> news:46034942@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.
>

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads