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.