Hello. I have an airport list (11000) and I would like to select all airports for a country in a new list without going through a loop. Is it possible ?
thank you in advance
store your airport list in a table in the sqlite database and get your airports for a country by using a select statement like this
SELECT airport FROM myTable WHERE country = <selected country>
Taifun
Thank you. It works.
So I have another question. Is it possible to integrate my SqlLite database into the APK?
thank you in advance
Hello. I have trouble expressing myself. What I would like to know is if it is possible to integrate a SqlLite database with the recorded data into the apk. thank you in advance
Friend, I posted the link where it shows the Kodolar Sqlite component. This component is the component that integrates Kodular + Sqlite. You read ?
Yes I read your post correctly. I did this :
test_SQLLite.aia (5.5 KB)
As you can see, I am filling my SqlLite database from a CSV file of 11000 records. This takes more than a minute. What I would like to do is memorize this SQL database and integrate it into the APK to avoid reading this CSV file every time
1 Like
Make sure that the database has already been filled. Record in tinydb an information that defines if the database has already been filled or not.