Hi Jason

I had no idea you could set the record position simply by setting
dataset.recNo. That works perfectly:)

Thanks very much for your help. My printing now works perfectly.
Rob

On 11/01/2012 12:07 p.m., IBO Support List wrote:
> 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
>
>
>
> ------------------------------------
>
> ___________________________________________________________________________
> IB Objects - direct, complete, custom connectivity to Firebird or InterBase
> without the need for BDE, ODBC or any other layer.
> ___________________________________________________________________________
> http://www.ibobjects.com - your IBO community resource for Tech Info papers,
> keyword-searchable FAQ, community code contributions and more ! Yahoo! Groups Links
>
>
>
>
>
> -----
> No virus found in this message.
> Checked by AVG - www.avg.com
> Version: 2012.0.1901 / Virus Database: 2109/4734 - Release Date: 01/10/12
>
>