Dataset navigation #2
lazarus / 16-Databases

----------------------------------------------------------------------
TRNelson · 2016-02-07 00:05

Is there a way of advancing the current record point by more than one
record in a similar fashion as using SQLQuery.Next, SQLQuery.Prior,
etc?

On a related note, where can you find a comprehensive description of
SQLQuery?

----------------------------------------------------------------------
Jurassic Pork · 2016-02-07 02:29

hello,
for this you can use the moveBy function.
For example to move to 2 records forward :
Code: Pascal  [Select][+][-]window.onload = function(){var x1 =
document.getElementById("main_content_section"); if (x1) { var x =
document.getElementsByClassName("geshi");for (var i = 0; i
 SQLQuery1.MoveBy(2);    
to move to 2 records backward :
Code: Pascal  [Select][+][-]window.onload = function(){var x1 =
document.getElementById("main_content_section"); if (x1) { var x =
document.getElementsByClassName("geshi");for (var i = 0; i
 SQLQuery1.MoveBy(-2);    
TSQLQuery is a subclass of TDataset. You can see the TDataset
functions here

Friendly, J.P

----------------------------------------------------------------------
TRNelson · 2016-02-07 05:37

Quote from: Jurassic Pork on February 07, 2016, 03:29:44 amhello,
for this you can use the moveBy function.
For example to move to 2 records forward :
Code: Pascal  [Select][+][-]window.onload = function(){var x1 =
document.getElementById("main_content_section"); if (x1) { var x =
document.getElementsByClassName("geshi");for (var i = 0; i
 SQLQuery1.MoveBy(2);    
to move to 2 records backward :
Code: Pascal  [Select][+][-]window.onload = function(){var x1 =
document.getElementById("main_content_section"); if (x1) { var x =
document.getElementsByClassName("geshi");for (var i = 0; i
 SQLQuery1.MoveBy(-2);    
TSQLQuery is a subclass of TDataset. You can see the TDataset
functions here

Friendly, J.P
Thank you for both bits of information. 

Very helpful!