lundi 10 août 2015

Android / JTDS / Select * from MSSQL WHERE NOT IN SQLITE

I have created a connection with a SQL Server in Android using JTDS. However as part of a synchronization method I need to only select rows in the SQL server database that I don't already have saved in the SQLite DB.

How could I create that query? My starting point is: ResultSet rs = st.executeQuery("SELECT * FROM List Where Status = 1");

Thanks

Aucun commentaire:

Enregistrer un commentaire