How do you display all the data in the first row taken from a MySQL database?

MIT App Inventor Help
1

I've done it and it works.
at this time I changed the data storage method to mysql in one column as shown below

image

How do I change the data in the coordinate column to a list to display again with this

image

i hope someone will help me

2

See the List picker.AfterPicking event from the example app how to do it

Screenshot_20221121_082955
Screenshot_20221121_0829551080×554 101 KB

Taifun

3

image

I want to display all the data in the first row of the coordinate column into lbl_Result, how do I do that?
i tried in this way

image

but only show one data.

4

you question actually is about how to select your data from your MySql database... this question actually is not related with the Location Service extension... I will move it into its own thread...

which result do you get after sending this SQL statement to your table?
SELECT kordinat FROM yourTablename WHERE trip = 8082749955

Taifun

5

i mean like this

the experiment I did before, 1 trip with a distance of 50 KM which coordinate was inputted into mysql as much as 285 rows,

image

I changed it by storing the data in only 1 row

image

This is my question, and I have solved it

image

this is the result

6

image
image305×630 76.9 KB

But when I choose another trip, an error message 3408 appears

7

this is your design decision... I would't have done it... you could have several rows for a trip in your table as you had it previously...

great

unfortunately I'm not familiar with that MySQL error and a Google search does not give any hint...
try to find out, what is different compared to the working row

Taifun

8

Thank you @Taifun for your attention and suggestions. I really appreciate it