即使数据库FMDBSwift中有数据，结果集也返回nil-ResultsetreturningnileventhereisdataindatabaseFMDBSwift

Hello I am using FMDB into my swift project. I copied my sqite file into documents directory and it success. I can get sqlite file which is copied into documents directory folder. I am inserting data into db as this:

你好我在我的swift项目中使用FMDB。我将sqite文件复制到文档目录中并成功。我可以将sqlite文件复制到文件目录文件夹中。我将数据插入数据库,如下所示:

if db.open() {
    let InsertQry = "insert into profiles (image_url, name,dob,gender) values ('\(imgName)','\(nameTxt.text!)','\(dobTxt.text!)','\(genderTxt.text!)')"
    print("query= \(InsertQry)")
    let result = db.executeUpdate(InsertQry, withArgumentsInArray: nil)
    if !result {
        print(db.lastErrorMessage())
    }
    else
    {
         print("Success")
    }
 }

And it insert data successfully I can see data in sqlite file using sqlite manager(Firefox Add-One plugin). Now I want to get all data from my table using this code:

它成功插入数据我可以使用sqlite manager(Firefox Add-One插件)在sqlite文件中查看数据。现在我想使用以下代码从我的表中获取所有数据:

if db.open() {
    let querySQL = "SELECT * FROM profiles"

    let results:FMResultSet? = self.db.executeQuery(querySQL,withArgumentsInArray: nil)
    if results?.next() == true {
       self.userProfilesArray = NSMutableArray()
       while results!.next() {
            let profileInfo = NSMutableDictionary()
           profileInfo.setObject(results!.stringForColumn("image_url"), forKey: "image_url")
            profileInfo.setObject(results!.stringForColumn("name"), forKey: "name")
            profileInfo.setObject(results!.stringForColumn("dob"), forKey: "dob")
            profileInfo.setObject(results!.stringForColumn("gender"), forKey: "gender")
            self.userProfilesArray.addObject(profileInfo) 
        }
     } else {
         print("results nil")
      }
    db.close()
} 

Issue is I am going into if results?.next() == true statement but I am not going to while loop and I am not getting data even there is data in my databse.

问题是我要进入结果?.next()== true语句但是我不打算循环,即使我的数据库中有数据,我也没有得到数据。

1 个解决方案