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
– Milan Gupta

2016-02-10 05:34:28 +00:00
Commented Feb 10, 2016 at 5:34 — Milan Gupta
– Milan Gupta, Commented Feb 10, 2016 at 5:34
it's showing any error ?. what is FMResultSet ?

Rince Thomas
– Rince Thomas

2016-02-10 05:35:11 +00:00
Commented Feb 10, 2016 at 5:35 — Rince Thomas
– Rince Thomas, Commented Feb 10, 2016 at 5:35

Vizllx · Accepted Answer · 2016-02-10 05:39:31Z

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, 2016 at 5:39

Vizllx

9,2261 gold badge43 silver badges79 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Retrieving values from SQLite table iOS

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related