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

    Hi,

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

    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.
     
  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.
     
Loading...
  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice