iOS 6 - SQLite3 Creating a Database Table (Part 3)

Part of the iOS 6 SQLite3 Database series. Demonstrates how to create a table in the database.

These are the videos in the iOS 6 SQLite3 Database Series:

Basic Database Terminology

iOS 6 - SQLite3 Database Intro (Part 1)

iOS 6 - Setting Up a SQLite3 Database (Part 2)

iOS 6 - Creating a Database Table (Part 3)

iOS 6 - SQLite3 Adding Records (Part 4)

iOS 6 - SQLite3 Database - Retrieve Records (Part 5)

[MrFerny]

Guys make sure your syntax looks correct, the teacher
made a very good job, please look carefully to the details, good luck!

[profgustin]

Hi, did you start with part 1 and part 2 of the database series? Those steps should be in place before trying to create your table.

[u]

I am ok! Thank you for the great tutorial!

[u]

I have already checked part 1 and part 2 of the database series, but I still have that error!

[Rafy]

I hate writing code I don't fully understand... But thanks a lot for the videos. Keep it up! I'll be going through your other vids to see what other goodies you have. 

[megacarlimeunier]

check your syntax, in my case i omitted "S" in EXITS.

[atsepa]

sweet lord i had the same mistake! damn u save me lol!

[kirarachang]

3Q~I will be check out Part1 and Part2!^^~

[TheDoloReel]

Everything she is doing is all good. Check your syntax 

[jimnanek]

I had a could not create table message also I changed the following to all CAPS and it worked?

@"CREATE TABLE IF NOT EXISTS

[bkasmai]

Hi
Great tutorial, you are a true gem. I created my database using FireFox Sqlite tool and then created a table and added a few records to it. I therefore decided not to use createTable method.When I tried to insert a record i got 'not such table' error. I then included the createTable and the error disappeared and managed to add a few records to the table but when I opened the database via Firefox tool the added records were absent! Any idea what I am doing wrong?

[jmhatutube]

One section of code you didn't go over (at least that I can remember or find) was the @synthesize under the @implementation. I'm fairly new to iOS development and knew in earlier versions you had to synthesize everything.  One video I saw said you don't have to do that any more, yet I got errors until I put the @synthesize code in.  Could you help me understand this better.  I'm using Xcode 5

[TheEmcol]

yes i did but still it is giving me that. help pls :/

[mukulbakshi]

its too confusing in writing statement, you use single quotes as well as double quotes in "sql" can you tell me where to use single quotes and double quotes.

[kirarachang]

i have mistake:add [self createTable:@"sumary" withField1:@"theDate" withField2:@"systolic"....];

'NSInternaInconsistencyException', reason:'Could not create table'
***First throw call stack:
pls help me!!><"...thanks a lot!

[satoboshi]

Does sqlite3 come along with Xcode ? OR is it a software I need to download separately ?

[Modius]

I habe this error message after the 3 part of this tutorial:

2013-01-17 20:18:30.711 BPApp[44959:c07] *** Assertion failure in -[MainViewController createTable:withField1:withField2:withField3:withField4:], /Users/Modius/X-Code
2013-01-17 20:18:30.713 BPApp[44959:c07] *** Terminating app due to uncaught exception 'NSInternalInconsistencyException', reason: 'Could not create table'

thanks for help