Retrieving values from SQLite table iOS

Question

As I'm new to iOS programming,I have a doubt in retrieving data corresponding to a particular integer id from SQLite database table?

This is what I tried but seems wrong:

NSInteger id=  sender.tag;
FMResultSet *rs = [self.databaseFM executeQuery:@"select * from tblVenue where venue_id = ?",id];

Is the problem related to Integer typecasting?

what are you using instead of "venue_id = ?" ? – Milan Gupta Feb 10 '16 at 05:34 — Milan Gupta, Feb 10 '16 at 05:34
it's showing any error ?. what is FMResultSet ? – Rince Thomas Feb 10 '16 at 05:35 — Rince Thomas, Feb 10 '16 at 05:35

score 1 · Accepted Answer · answered Feb 10 '16 at 05:39

1

Just use -numberWithInteger: like this :-

NSInteger id=  sender.tag;
FMResultSet *rs = [self.databaseFM executeQuery:@"select * from tblVenue where venue_id = ?", [NSNumber numberWithInteger:id]];

answered Feb 10 '16 at 05:39

Vizllx

9,135
1
41
79

Retrieving values from SQLite table iOS

1 Answers1