B4J Question MySQL Server Time

ExecQuery returns a ResultSet, so the log output makes sense (you're seeing a ResultSet.toString() output). For a quick video primer, go to https://www.b4x.com/etp.html and look at the "SQL & Relational Databases" video. Also, there are the following posts:
https://www.b4x.com/android/forum/threads/b4x-documentation-booklets.88985/#content (look at the SQLite tutorial. Many things will apply across DB's)

Better to use async methods with remote databases.

[B4X] SQL with Wait For

Erel said:

Better to use async methods with remote databases.

[B4X] SQL with Wait For

Click to expand...

Thank you for taking the time to post a reply

I went thru that post and could not find anything related to server time.

The problem I am trying to solve is there will be multiple remote users in many different countries. The only thing I could think about to syncro them all at the same time was the SERVER time which specified at GMT.

Since then I have written a php file to get the server time on the server and brought that into the program so that I could then start everybody at the same time.

I thought of using something like Push notifications but that as far as I see will only work on Mobile Applications, I need all the platforms. Possibly MTQQ but as this is a free program I do not want to incur costs

Basically writing a Quiz program for people in Isolation/ Lockdown (COVID-19) that can create their own groups of individual quiz games with multiple categories and is based on time. I have seen a lot of these games which goes back to a server and sometimes connection are poor and even though that person answered the fastest, they came in second or third. So the idea is to time them from when the question appears on their screen to the time they choose the correct answer, then send that to the server. The game has a 30 second wait after each round to collect from all the players and display the result of that round.

So when any of the users initiates a game then this code is run and the server time along with 5 minutes extra is put into the game file which when any of the other remote users join the game, the start time of the game is on their own computers.

Peter Lewis said:

Thank you for taking the time to post a reply

I went thru that post and could not find anything related to server time.

Click to expand...

It was not related. It was a tip to help you build an app that doesn't freeze the UI while the query is made.