Querying local geodatabase "EXC_BAD_ACCESS" error

philwillis

I'm trying to query a local-geodatabase and display the results in a TableView however i'm having a thread error "EXC_BAD_ACCESS". I assume cause i have to be on the main thread to update the UI. I've tried using the performSelectorOnMainThread:@selector(reloadData) on the tableView but no luck!


<property for table array>

@property (nonatomic, strong) NSArray *localGDBQueryResult;

<method to query the database>

-(void) localgeodatabaseSearchForValue:(NSString*)searchString {   NSError *GDBError;   AGSGDBGeodatabase *gdb = [AGSGDBGeodatabase geodatabaseWithName:@mygeodb error:&GDBError];         if (gdb) {      AGSGDBFeatureTable *table = [gdb featureTableForLayerName:@Mileposts];          NSString *fieldname = @MPOINT;     AGSQuery *query = [[AGSQuery alloc] init];     query.where = [NSString stringWithFormat:@%@ = '%@'",fieldname, searchString];          [table queryResultsWithParameters:query           completion:^(NSArray *results, NSError *error) {                              if (!error) {                   self.localGDBQueryResult = results;                   [self.searchDisplayController.searchResultsTableView performSelectorOnMainThread:@selector(reloadData)                                                                                         withObject:nil                                                                                      waitUntilDone:NO];               } else {                   // Log details of the failure                   NSLog(@Error: %@ %@", error, [error userInfo]);               }           }];   } }

<tableview methods>

 - (NSInteger)numberOfSectionsInTableView:(UITableView *)tableView {  return 1; }  - (NSInteger)tableView:(UITableView *)tableView  numberOfRowsInSection:(NSInteger)section {  return [self.localGDBQueryResult count]; }  - (UITableViewCell *)tableView:(UITableView *)tableView          cellForRowAtIndexPath:(NSIndexPath *)indexPath {  UITableViewCell *cell = [self.tableView dequeueReusableCellWithIdentifier:@cell];       if (!cell) {      cell = [[UITableViewCell alloc] initWithStyle:UITableViewCellStyleDefault                                       reuseIdentifier:@cell];  }     cell.textLabel.text = [[self.localGDBQueryResult objectAtIndex:indexPath.row] valueForKey:@RoadName];  return cell; } 

philwillis

ended up dumping the results into a dictionary and working the the keys

@property (nonatomic, strong) NSArray *queryArrayResults; @property (nonatomic, strong) AGSGDBFeatureTable *table;

-(void) localgeodatabaseSearchForValue:(NSString*)searchString {     NSError *GDBError;     AGSGDBGeodatabase *gdb = [AGSGDBGeodatabase geodatabaseWithName:@mygeodb error:&GDBError];       if (gdb) {                  self.table = [gdb featureTableForLayerName:self.segmentSelection];         NSString *fieldname = @Mileposts;          AGSQuery *query = [[AGSQuery alloc] init];         query.where = [NSString stringWithFormat:@%@ = '%@'",fieldname, searchString];                  [self.table queryResultsWithParameters:query                                     completion:^(NSArray *results, NSError *error) {                                                      if (!error) {                 NSArray *arr = results;                 NSMutableArray *mutArr = [[NSMutableArray alloc]init];                 for (int i =0; i<[arr count]; i++) {                     AGSGDBFeature *feat =[arr objectAtIndex:i];                     NSDictionary *dic = [[NSDictionary alloc] initWithDictionary:[feat allAttributes]];                     [mutArr addObject:dic];                                      }                 self.queryArrayResults = [mutArr copy];                  // reload the table                 [self.searchDisplayController.searchResultsTableView performSelectorOnMainThread:@selector(reloadData)                                                                                       withObject:nil                                                                                    waitUntilDone:NO];             } else {                 // Log details of the failure                 NSLog(@Error: %@ %@", error, [error userInfo]);             }         }];     } }

and finally the tableView

- (NSInteger)tableView:(UITableView *)tableView  numberOfRowsInSection:(NSInteger)section {  return [self.queryArrayResults count]; }  - (UITableViewCell *)tableView:(UITableView *)tableView          cellForRowAtIndexPath:(NSIndexPath *)indexPath {  UITableViewCell *cell = [self.tableView dequeueReusableCellWithIdentifier:@cell];       if (!cell) {      cell = [[UITableViewCell alloc] initWithStyle:UITableViewCellStyleDefault                                       reuseIdentifier:@cell];  }      cell.textLabel.text = [[self.queryArrayResults objectAtIndex:indexPath.row] objectForKey:@RoadName];        return cell; }