Watch, Follow, &
Connect with Us

For forums, blogs and more please visit our
Developer Tools Community.


Welcome, Guest
Guest Settings
Help

Thread: Problem with clientdataset packetrecords



Permlink Replies: 1 - Last Post: Aug 17, 2017 11:49 AM Last Post By: Jeff Overcash (...
Rodrigo Baltazar

Posts: 3
Registered: 6/9/15
Problem with clientdataset packetrecords
Click to report abuse...   Click to reply to this thread Reply
  Posted: Aug 16, 2017 2:07 PM
Good morning, everyone, if possible I would like your help,

We are doing a test with delphi 10.2 however, we mark the clientdataset property the packerdrecords for 10 and it returns only the first 10 records. If you keep rolling, you will not bring anything else. I think the correct thing would be to bring it 10 out of 10 would not it? Or am I setting it wrong?

If anyone can help.
Grateful
Jeff Overcash (...

Posts: 1,529
Registered: 9/23/99
Re: Problem with clientdataset packetrecords
Click to report abuse...   Click to reply to this thread Reply
  Posted: Aug 17, 2017 11:49 AM   in response to: Rodrigo Baltazar in response to: Rodrigo Baltazar
Rodrigo Baltazar wrote:
Good morning, everyone, if possible I would like your help,

We are doing a test with delphi 10.2 however, we mark the clientdataset property the packerdrecords for 10 and it returns only the first 10 records. If you keep rolling, you will not bring anything else. I think the correct thing would be to bring it 10 out of 10 would not it? Or am I setting it wrong?

If anyone can help.
Grateful

Works as expected to me. I just used the Employee table from the IB employee
db. Attached a DBGrid to it and opened the ClientDataset. The first 10 records
populated the grid and as I scrolled down it would fetch the next ten etc until
all records were finally retrieved.

When you say only return the first 10 I think this is a misunderstanding.
PacketRecords determines how many records at a time to bring back, not limit the
total number to bring back.

When -1 (default) it says when open pull all data right now. Large dataset this
can be time consuming so you can set it to bring back a smaller subset and as
the user scroll through the data go back and get more as needed.

Setting it to 0 says only do a meta data pull of the result set but no data.

If you want to limit the number of row in the result set you should do that as
part of the SQL (like InterBase was it's rows clause).

--
Jeff Overcash (TeamB)
(Please do not email me directly unless asked. Thank You)
Learning is finding out what you already know. Doing is demonstrating that you
know it. Teaching is reminding others that they know it as well as you. We are
all leaners, doers, teachers. (R Bach)
Legend
Helpful Answer (5 pts)
Correct Answer (10 pts)

Server Response from: ETNAJIVE02