how to iterate the result from AGSGDBFeatureTable.queryResultsWithParameters

MeiWei

I got exception to access the results from queryResultsWithParameter, can someone please help?

let localFeatureTable = geodatabase.featureTables()[1] as! AGSGDBFeatureTable

localFeatureTable.queryResultsWithParameters(query , completion: { (tmpResult, error ) -> Void in

               

                print("error is \(error); result count is \(tmpResult.count)")

                let results = tmpResult as! [AGSFeature]

                for feature in results  {

                    print("feature: \(feature)")               <--- this line throws EXC_BAD_ACCESS

                }

YueWu1

Hi Mei Wei,

I think the way you using the new Swift2 do...try...catch syntax is not correct and also I am not really sure the way that you load the bundle may has some issue.

I do based on an offlineRouting sample and add the method queryResultsWithParameters. It works fine and return 310 results. I would suggest to instantiate the AGSGDBGeodatabase & AGSGDBFeatureTable after the viewController

    var localGDB: AGSGDBGeodatabase!
    var localFeatureTable: AGSGDBFeatureTable!

Then use this format to handle the error based on The Swift Programming Language (Swift 2.1): Error Handling

do {

try expression

statements

} catch pattern 1 {

statements

} catch pattern 2 where condition {

statements

}

And I tested with this code and it works. Hope this can help.

        if let gdbPath = NSBundle.mainBundle().pathForResource("RuntimeSanFrancisco", ofType: "geodatabase"){
        
            do{
               try self.localGDB = AGSGDBGeodatabase(path: gdbPath)
                
                localFeatureTable = localGDB.featureTables()[0] as! AGSGDBFeatureTable
                
                print ("how many features \(localFeatureTable.featureCount())")
                print("service layer \(localFeatureTable.serviceLayerName)")
                
                localFeatureTable = localGDB.featureTables()[0] as! AGSGDBFeatureTable
                
                print ("how many features \(localFeatureTable.featureCount())")
                print("service layer \(localFeatureTable.serviceLayerName)")
                
                print("field size \(localFeatureTable.fields().count)")
                for field in localFeatureTable.fields() {
                    print("field is \(field.name)")
                }
                
                let query: AGSQuery = AGSQuery()
                //query.geometry = self.mapView.maxEnvelope
                query.whereClause = "NAME Like 'Market%'"
                localFeatureTable.queryResultsWithParameters(query , completion: { (result, error ) -> Void in
                    
                    print("error is \(error); result count is \(result.count)")
                    let newResult = result as! [AGSGDBFeature]
                    for feat in newResult {
                        print("\(feat)")
                        //  feat.allAttributes()
                    }
                })
            } catch let error1 as NSError {
                error = error1
                print("what is error \(error)")
                self.routeTask = nil
            }
        }