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

Discussion in 'Android Questions' started by vdudukov, Jul 17, 2015.

  1. vdudukov

    vdudukov Member Licensed User


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


    Dim ListOfProducts As List
                    ListOfProducts = parser.NextArray 
    'returns a list with maps
    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 ?

  2. jmon

    jmon Well-Known Member Licensed User

    DonManfred likes this.
  3. sorex

    sorex Expert Licensed User

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