TbQuery back N records

Question

TbQuery back N records

Navigation

#1 by (0 votes)

1

In delphi if I give a TbQuery.prior it returns a record. But if I want to return N records, for example, I want to go back 5 records. Does anyone know if there is any method in delphi that does this?

sql delphi delphi-7

asked by anonymous 20.06.2016 / 20:44

1 answer

Grunt Concat Does Not Unify Files Getting record id

score 0 · Accepted Answer

You can use the MoveBy(Distance: Integer) method.

With this method you indicate in the parameter where you want to move the cursor of the current record.

Positive values move the forward cursor in the dataSet and negative values to back .

In your example use TbQuery.MoveBy(-5);