Ios – SQLite ‘no such table’ error

ios-simulatoriphoneiphone-sdk-3.0macosobjective c

I'm noob here but, why is it i'm getting this error?

I DO have a table named Team in an SQLite called Team.sqlite! Is there anything else I need to provide?

ERROR
---------------
2009-12-23 23:17:05.277 PitScout[6690:207] *** Assertion failure in -[Team addTeam], /Users/******/Desktop/PitScout/Classes/Team.m:90
2009-12-23 23:17:05.280 PitScout[6690:207] *** Terminating app due to uncaught exception 'NSInternalInconsistencyException', reason: 'Error while creating add statement. 'no such table: Team''
2009-12-23 23:17:05.280 PitScout[6690:207] Stack: (
    30131291,
    2502464777,
    30215227,
    810772,
    16329,
    12146,
    20588,
    2753625,
    4667381,
    2753625,
    3160994,
    3169731,
    3164943,
    2858547,
    2766876,
    2793653,
    37420753,
    29916032,
    29912136,
    37414797,
    37414994,
    2797571,
    10780,
    10634
)

Best Answer

Use CoreData. Using SQLite directly is harder, requires more code, and is a waste of time unless you have very specific needs.
You say:

I DO have a table named Team in an SQLite called Team.sqlite! Is there anything else I need to provide?

This doesn't make sense. Are you saying you have a database named "Team.sqlite"? Or do you have a table named "Team.sqlite"? A table named "Team.sqlite" is not the same as a table named "Team".

How do you create the table? I.e. what is the CREATE TABLE statement you are using?

Related Solutions

Ios – How to load a UIView using a nib file created with Interface Builder

There is also an easier way to access the view instead of dealing with the nib as an array.

1) Create a custom View subclass with any outlets that you want to have access to later. --MyView

2) in the UIViewController that you want to load and handle the nib, create an IBOutlet property that will hold the loaded nib's view, for instance

in MyViewController (a UIViewController subclass)

  @property (nonatomic, retain) IBOutlet UIView *myViewFromNib;

(dont forget to synthesize it and release it in your .m file)

3) open your nib (we'll call it 'myViewNib.xib') in IB, set you file's Owner to MyViewController

4) now connect your file's Owner outlet myViewFromNib to the main view in the nib.

5) Now in MyViewController, write the following line:

[[NSBundle mainBundle] loadNibNamed:@"myViewNib" owner:self options:nil];

Now as soon as you do that, calling your property "self.myViewFromNib" will give you access to the view from your nib!

Ios – Xcode – How to fix ‘NSUnknownKeyException’, reason: … this class is not key value coding-compliant for the key X” error

You may have a bad connection in your xib.

I've had this error many times. While TechZen's answer is absolutely right in this case, another common cause is when you change the name of a IBOutlet property in your .h/.m which you've already connected up to File's Owner in the nib.

From your nib:

Select the object in IB and go to the 'Connections Inspector'.
Under 'Referencing Outlets' make sure that your object isn't still connected to the old property name... if it is, click the small 'x' to delete the reference and build again.

Another common cause if you are using Storyboard, your UIButton might have more then one assignings (Solution is almost the same as for nib):

Open your storyboard and right click the UIButton
You will see that there is more than one assign/ref to this button. Remove one of the "Main..." greyed windows with the small "x":

Best Answer

Related Solutions

Ios – How to load a UIView using a nib file created with Interface Builder

Ios – Xcode – How to fix ‘NSUnknownKeyException’, reason: … this class is not key value coding-compliant for the key X” error

You may have a bad connection in your xib.

Related Topic