You have to change all that when you switch from SQLserver to SQLite
1) TOP 1 -> LIMIT 1
SELECT TOP 1 Fields becomes WHERE Contition LIMIT 1
2) NOT NULL
NOT [Field] IS NULL becomes [FIELD] IS NOT NULL
3) DataTable -> DataReader
DataTable becomes DataReader
4) EOF-> HasRows
.EOF == true becomes .HasRows == false
5) SYSDATETIME() wird CURRENT_TIMESTAMP
[dtScan] = CURRENT_TIMESTAMP"; //SYSDATETIME()
string sSQL = "SELECT [IDProject_On_Server] FROM tbl_Details WHERE [dtDeleted] IS NOT NULL"; SqliteDataReader dataReader = clsDB.Get_DataReader(sSQL); if (dataReader.HasRows == true) { while(dataReader.Read()) { //---< NoMatch: Delete on Server >--- string IDProject_on_Server = dataReader["IDProject_on_Server"].ToString(); fx_Log("delete byWebsite" + IDProject_on_Server); //</ nomatch >
|
Data Reader
SqliteDataReader dataReader = clsDB.Get_DataReader(sSQL); |
Will with
SqliteDataReader dataReader = clsDB.Get_DataReader(sSQL);
|