FMDB WHERE clause

🎤 General Discussion Swift
1

Hi

Could not retrieve row with WHERE but I can retrieve all rows. Plz check code.

func retrieveData()
{
let contactDB = FMDatabase(path: databasePath as String)

    if contactDB.open()
    {                 
        //this shows record not found
        let results: FMResultSet? = contactDB.executeQuery("SELECT * FROM CONTACTS WHERE Id = '005700000045CTkAAM'", withArgumentsInArray: nil)
        
        //this shows all records
        //let results: FMResultSet? = contactDB.executeQuery("SELECT * FROM CONTACTS", withArgumentsInArray: nil)             
        
        if results?.next() == true
        {
             print("results Id \(results?.stringForColumn("Id")), Name \(results?.stringForColumn("Name"))")
        }
        else
        {
             print("retrieveData record not found")
        }
        contactDB.close()
    }
    else
    {
        print("retrieveData contactDB cannot open Error: \(contactDB.lastErrorMessage())")
    }
}