Subject | RE: [IBO] Jumping to a record number in a dataset (Query or table) |
---|---|
Author | IBO Support List |
Post date | 2012-01-10T23:07:02Z |
Rob,
MoveBy() is to jump over records.
Sounds to me like you want to just do something like this:
{Might be RowNum instead of RecNo}
RecNo := 1000;
While RecNo < 1100 do
Begin
...
Next;
End
Jason
-----Original Message-----
From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com] On Behalf
Of Robert Martin
Sent: 10 January 2012 03:54 PM
To: IBObjects@yahoogroups.com
Subject: [IBO] Jumping to a record number in a dataset (Query or table)
Hi
I have printing code where if the user selects page 10 (for example) I
want to jump to record 1000 and then print the next 100 records.
Printing is run from a TDataSet although if need be this could be changed.
I see a dataset has a MoveBy() command, would this be the best way of
achieving this or does this have performance implications? I cant re
run the query as it is in use by other components.
Thanks
Rob
MoveBy() is to jump over records.
Sounds to me like you want to just do something like this:
{Might be RowNum instead of RecNo}
RecNo := 1000;
While RecNo < 1100 do
Begin
...
Next;
End
Jason
-----Original Message-----
From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com] On Behalf
Of Robert Martin
Sent: 10 January 2012 03:54 PM
To: IBObjects@yahoogroups.com
Subject: [IBO] Jumping to a record number in a dataset (Query or table)
Hi
I have printing code where if the user selects page 10 (for example) I
want to jump to record 1000 and then print the next 100 records.
Printing is run from a TDataSet although if need be this could be changed.
I see a dataset has a MoveBy() command, would this be the best way of
achieving this or does this have performance implications? I cant re
run the query as it is in use by other components.
Thanks
Rob