SQLite: still stuck with navigation

Databases
1

To makle the things clear and short, what code can I place in the arrow buttons to display the next Release Note ?

image
image1424×1082 178 KB

2

Assuming the text is in a SQLite table you need to fetch the next record. Study the examples on how to browse a database/table. But if you know how to get this first record, fetching the next shouldn’t be much of a problem. Write a method that retrieves a RowSet with a SelectSQL query and browse through the RowSet…

3

I have not tried the code below. But this might be something you are looking for, I think…

// the "rs" variable below is a RowSet object, with your release note data

// Arrow Right Button: Next
If Not rs.AfterLastRow Then
  rs.MoveToNextRow
Else
  rs.MoveToFirstRow
End

// Arrow Left Button: Previous
If Not rs.BeforeFirstRow Then
  rs.MoveToPreviousRow
Else
  rs.MoveToLastRow
End

You could remove the MoveToLastRow and MoveToFirstRow in case you don’t want to go to the first or last record, if you reach the last or first record.

See the Xojo documentation for more info.

4

If you keep tabs on which record you’re up to, you can use the SQL OFFSET parameter to just load the records you want.