Android Question Scroll to a particular MYSQL record?

[dlfallen]

I have a mysql database program that has served me well for a long time (Bluesky Database, in Share My Creations).

This program uses DButils and I use webview extras' PageUp and PageDown capabilities. In addition to scrolling a page up or down (or to an end) I would like to be able to scroll to a particular record (say ID=355). Is this possible? That is, I want all records in the view but with the top row displayed being a particular row.

 

[Erel]

You can use TableView or FlexibleTable classes: https://www.b4x.com/android/forum/threads/class-tableview-supports-tables-of-any-size.19254/#content

 

[dlfallen]

You can use TableView or FlexibleTable classes: https://www.b4x.com/android/forum/threads/class-tableview-supports-tables-of-any-size.19254/#content

Thank for the suggestion Erel. For quite a while now I have been contemplating the use of flexible tables in my program. I am sure it is not quite as simple as just changing the table definition. Your own post on the table class states "It shouldn't be difficult to show SQL tables using DBUtils.ExecuteMemoryTable." so I am sure some tweaking would be necessary. Maybe next Fall I can have enough time to figure all this out (I have seen no example of using flexible tables with DBUtils) - but I am behind in my readings . . .).

I was hoping for a quick fix to my existing code, thinking that since programmatic control of scrolling is possible (i.e. PageDown using webview extras) perhaps other programmatic scrolling might be possible. However, since I plan to change over to flexible tables at some point, perhaps I should just live with my current code and spend my efforts on learning how to use the table class with DBUtils.

Thanks again for the suggestion and for your (always) spectacular support.

 

[Erel]

It is simple. I think that FlexibleTable class includes such a method. If not you just need to call DBUtils.ExecuteMemoryTable and then add the records to the table view.

 

[dlfallen]

Thanks Erel. I shall give it a rry after my holidays. Have a great Summer!