Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- My iPhone project doesn't fetch more than 5 rows of the sqlite table?
- if(sqlite3_open([dbPath UTF8String],&database)==SQLITE_OK){
- const char* sql2= " select * from Bcars";
- sqlite3_stmt *selectstatment;
- if(sqlite3_prepare_v2(database,sql2,-1,&selectstatment,Nil)==SQLITE_OK){
- while(sqlite3_step(selectstatment)==SQLITE_ROW){
- // fetch the id
- count[i++]=sqlite3_column_int(selectstatment, 0);
- carobject.primarykey=sqlite3_column_int(selectstatment, 0);
- [ar addObject:[NSString stringWithUTF8String:(char*)sqlite3_column_text(selectstatment, 1)]];
- [ar1 addObject:[NSString stringWithUTF8String:(char*)sqlite3_column_text(selectstatment, 2)]];
- }
- }
- }
- else
- {
- sqlite3_close(database);
- self.statustext.text=@" database closed";
- }
- self.statustext.text=[[NSString alloc]initWithFormat:@"%d",count[4]];/* when I try to return count[5] it gives me rabbish value !!*/
- self.searchtext.text=(NSString*)[ar objectAtIndex:5];//here is an error occurred !!
Add Comment
Please, Sign In to add comment