Subscribe ( )

iPhone Programming Tutorials


 

Forum

You must be logged in to post Login Register

Search 

Home Forums General Multiple table in a sqlite db

Multiple table in a sqlite db
Page:   1  
User Post

1:36 pm
October 22, 2008


jab2109

iCoder

posts 8
1

Is there anything special that needs to be done when implementing a database with multiple tables? I am having problems with the sqlite3_prepare function when querying data on a database with more than one table. If I run some query in the terminal, it executes fine, but in XCode, I am getting errors about tables and columns not being found.

3:43 pm
October 22, 2008


AdeC

iCoder

posts 17
2

There is nothing special that needs to be done when implementing multiple tables. The only thing that you have to bear in mind is that the sql needs to change depending on what data you need to get and from where.

If you post your table structures an the sql you are trying to use that will help in finding a solution.

5:07 pm
October 22, 2008


jab2109

iCoder

posts 8
3

This might save someone a lot of trouble, or just make me look like an idiot… If you are replacing/updating a table in your sqlite database, UNINSTALL YOURE APPLICATION before you run it again. Thanks anyway AdeC.
Page:   1  
Topic RSS 
Search 

About the iCodeBlog forum

Most Users Ever Online:

44


Currently Online:

3 Guests

Forum Stats:

Groups: 2

Forums: 6

Topics: 419

Posts: 893

Membership:

There are 935 Members

There has been 1 Guest

There are 2 Admins

There is 1 Moderator

Top Posters:

bobcubsfan – 54

crazyiez – 30

Uhu – 17

AdeC – 17

Nick – 15

jitesh61 – 12

Administrators: Brandon (88 Posts), Collin (0 Posts)

Moderators: VertigoSol (26 Posts)


©   

  • Posted by on 6 Aug 2008 in Uncategorized
  •   |  
  •   |  
  •   |  
  • Comments Off

Comments are closed.