Hi, I selecting the row of the table. The text of the row i stored in the application delegate object as a NSString. That NSString i want to retrieving or binding in SELECT statement of SQLite query, For that i written code in the TableView Class

• (void)tableView:(UITableView *)tableView didSelectRowAtIndexPath:(NSIndexPath *)indexPath {

  selectedText = [appDelegate.categoryArray objectAtIndex:indexPath.row]; appDelegate.selectedTextOfRow = selectedText; ListOfPrayersViewController *listVC = [[ListOfPrayersViewController alloc] init]; [self.navigationController pushViewController:listVC animated:YES];

  [listVC release]; }

and database class class code is. + (void) getDuas:(NSString *)dbPath{

    if(sqlite3_open([dbPath UTF8String], &database) == SQLITE_OK){
        SalahAppDelegate *appDelegate = (SalahAppDelegate *)[[UIApplication sharedApplication] delegate];
        NSString *categoryTextForQuery =[NSString stringWithFormat:@"SELECT Category FROM Prayer WHERE Category ='%s'", appDelegate.selectedTextOfRow ];
        NSLog(@"The Text %@", categoryTextForQuery);
        //const char *sqlQuery1 = (char *)categoryTextForQuery;
        //const char *sqlQuery = "SELECT Category FROM Prayer WHERE Category = 'Invocations for the beginning of the prayer'"; 
        sqlite3_stmt *selectstmt;
        if(sqlite3_prepare_v2(database, [categoryTextForQuery UTF8String], -1, &selectstmt, NULL) == SQLITE_OK){
            appDelegate.duasArray =[[NSMutableArray alloc] init];
            while(sqlite3_step(selectstmt) == SQLITE_ROW){
                NSString *dua = [[NSString alloc] initWithCString:(char *)sqlite3_column_text(selectstmt,0) encoding:NSASCIIStringEncoding];
                Prayer *prayerObj = [[Prayer alloc] initwithDuas:dua];
                prayerObj.DuaName = dua;
                [appDelegate.duasArray addObject:prayerObj];
            }
        }
    }
}

The code is comes out of loop on the statement or starting the loop of the while(sqlite3_step(selectstmt) == SQLITE_ROW) Why? How i bind the table selected text in SELECT statement of sqlite?