B4J Question Busy indicator

atiaust

Active Member
Licensed User
Longtime User
Hi all,

I want to show a small progress indicator while a database is loaded to a table so that the user can see something is happening, like a mouse pointer timer or similar any ideas?

Thanks
 

atiaust

Active Member
Licensed User
Longtime User
Hi Erel,
I am loading 79,600 records from a Raspberry Pi Mysql server over WIFI.

It takes about 20 seconds to fill the table which is pretty good.

I am using form.showAndWait to keep the form on top and have to load the table before showing the form.
Tried showing the form first but the data doesn't show.

Would like to show a spinner while data is loading.

Thanks
 
Upvote 0

atiaust

Active Member
Licensed User
Longtime User
The data file is from a data logger. There shouldn't normally be that many records.

How can I read the data back in blocks? What would the MySQL query be?

Thanks
 
Upvote 0

Daestrum

Expert
Licensed User
Longtime User
How can I read the data back in blocks? What would the MySQL query be?

If I remember correctly you can use LIMIT with 2 parameters. ie SELECT * from .... LIMIT 1,10
I think the first param is the offset and the second is the number of rows to return. (Worth a google to confirm).
 
Upvote 0
Top