SQLITE31 sqlite3 select할때 한 줄만 주구장창 나온다면? func selectSiteData(clientName: String) -> [TrustedSiteData]{ //데이터 조회 let selectQuery = "select * from sitetable where clientname like '%\(clientName)%'" var statement: OpaquePointer? = nil var result: [TrustedSiteData] = [] if sqlite3_prepare_v2(self.db, selectQuery, -1, &statement, nil) == SQLITE_OK { while (sqlite3_step(statement) == SQLITE_ROW){ let result1 = Int(sqlite3_column_int(statemen.. 2022. 12. 22. 이전 1 다음