I need to get the total row count for the "Main" table in my SQL DB but can't find out how to get it.
I made a touch scrollbar for Gecko that gets 12 entries from an offset determined by the Mousedown coordinates and displays them with FDrawString.
This is how I get the OFFSET value for my query:
Then I do this to display 12 results I will show with Drawstring on my Form (The background image is the UI)
I made a touch scrollbar for Gecko that gets 12 entries from an offset determined by the Mousedown coordinates and displays them with FDrawString.
This is how I get the OFFSET value for my query:
(Y position from the scrollbar top) / (Scrollbar height) * (SQL table's row count)
Then I do this to display 12 results I will show with Drawstring on my Form (The background image is the UI)
SQLCmd.CommandText="SELECT Name FROM Main LIMIT 12 OFFSET "
SQLCmd.ExecuteTable("tblList",0)