Guest User

Untitled

a guest
Aug 21st, 2018
82
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.10 KB | None | 0 0
  1. My iPhone project doesn't fetch more than 5 rows of the sqlite table?
  2. if(sqlite3_open([dbPath UTF8String],&database)==SQLITE_OK){
  3.  
  4. const char* sql2= " select * from Bcars";
  5.  
  6. sqlite3_stmt *selectstatment;
  7.  
  8. if(sqlite3_prepare_v2(database,sql2,-1,&selectstatment,Nil)==SQLITE_OK){
  9.  
  10. while(sqlite3_step(selectstatment)==SQLITE_ROW){
  11. // fetch the id
  12.  
  13.  
  14. count[i++]=sqlite3_column_int(selectstatment, 0);
  15.  
  16. carobject.primarykey=sqlite3_column_int(selectstatment, 0);
  17.  
  18.  
  19. [ar addObject:[NSString stringWithUTF8String:(char*)sqlite3_column_text(selectstatment, 1)]];
  20. [ar1 addObject:[NSString stringWithUTF8String:(char*)sqlite3_column_text(selectstatment, 2)]];
  21.  
  22.  
  23. }
  24. }
  25.  
  26. }
  27. else
  28. {
  29.  
  30. sqlite3_close(database);
  31. self.statustext.text=@" database closed";
  32. }
  33.  
  34. self.statustext.text=[[NSString alloc]initWithFormat:@"%d",count[4]];/* when I try to return count[5] it gives me rabbish value !!*/
  35.  
  36. self.searchtext.text=(NSString*)[ar objectAtIndex:5];//here is an error occurred !!
Add Comment
Please, Sign In to add comment