ios - SELECT from VIEW with FMDB -
i have sqlite database following tables:
- player
- card
- team
- playercard
carddatacomposed view created following select:
select player.playerid, player.playerfirstname, player.playerlastname, card.cardid, team.teamid, team.teamname player, card, playercard, team player.playerid=playercard.playerid , card.cardid=playercard.cardid , team.teamid=playercard.teamid;
using sqlite3 command line tool, select * carddatacomposed
returns of records. using same query fmdb:
nsstring *dbquery = @"select * carddatacomposed"; [self.database executequery:dbquery];
does not return records. imagine has how i'm (incorrectly) putting query fmdb can retrieve records properly. how fix query select records view? able query views fmdb? in advance!
i had delete contents of documents directory in simulator see changes made database. above query works expected.
Comments
Post a Comment