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

Popular posts from this blog

css - Which browser returns the correct result for getBoundingClientRect of an SVG element? -

gcc - Calling fftR4() in c from assembly -

Function that returns a formatted array in VBA -