🚀 go-pugleaf

Hello Bob,

I managed to get it to work but what I had to do was the following:

      DataSet1.Dispose;
      DataSet1 := Dataset.Create;
      lItemCount := daRequests.Fill(Dataset1);

which seems really inefficient since it implies that on each Pageindex
change I go and get all the data again. I guess I just don't understand
these objects because it seemed to me that once I had used the Fill() the
data should be available in the dataset so that any requests such as for a
different page index would simply use whatever was in the dataset at the
time the request was made.

I am not using the BDP objects but rather the OLEDB objects. Is there any
particular reason to use one over the other?

I will check the reference you posted - thank you for that! And I would also
like to offer a general thanks to you for your generosity in giving your
time and sharing your knowledge in these group postings! I have learned a
lot from many of your answers to others and postings and I can't thank you
enough for that!!!

James


"Bob Swart" <b.swart@chello.nl> wrote in message
news:45A0CBC6.4090602@chello.nl...
> Hi James,
>
> > I am trying to use a datagrid control and enable paging. No matter what
I do I get the following errror:
> > Invalid CurrentPageIndex value. It must be >= 0 and < the PageCount.
> > even though if I step through and debug I see that the pageindex I am
attempting to set (1) is less than the page count (2).
>
> But when you call DataBind on the DataGrid again, does the DataGrid's
> DataSource still contain the data? Did you re-execute the query, or
> obtain the data from a cache (like the session for example?).
>
> Note that if you use BdpDataAdapter, then leaving the Active property
> set to True will do the trick (it's not as efficient as storing the
> result in the session, but at least ensures the query will always be
> re-executed).
>
> > I have searched for this message in the newsgroups and cannot find any
answer that applies. Has anyone had this problem and been able to resolve
it?
>
> See
>
http://www-128.ibm.com/developerworks/db2/library/techarticle/dm-0401swart/
> for an example how to do it using BdpDataAdapter.
>
> > Thanks,
> > James
>
> Groetjes,
>            Bob Swart
>
> -- 
> Bob Swart Training & Consultancy (eBob42.com)  Forever Loyal to Delphi
> Blog: http://www.drbob42.com/blog - RSS: http://drbob42.com/weblog.xml
> New Delphi 2006 Courseware e-books at http://www.eBob42.com/courseware