Android Question Insert list of records from MYSQL (Check if exist)

[vdudukov]

Hi,

I am trying to insert list of records from MYSQL database to SQLite.
I did it with this code:

Case: "updateSQLite"

                Dim ListOfProducts As List
                ListOfProducts = parser.NextArray 'returns a list with maps
                DBUtils.InsertMaps(SQLite,"products",ListOfProducts)
               
End Select

Now i want to check every record if exist in my SQlite database. If do not exist, then insert, if exist then return.

How can I do this ?

Thanks.

 

[jmon]

This is not really related to B4A. You should search on internet : https://stackoverflow.com/questions/3634984/insert-if-not-exists-else-update

Have a look here if you don't know how to use SQL in B4X : https://www.b4x.com/android/forum/threads/sql-tutorial.6736/#content

 

[sorex]

you will need to do it in your own loop and use a select statement to see if that record/product already exist.