Create a sqlite3 table programmatically

[franium]

Hi all,
I have to add programmatically two tables to a sqlite3 database.
Have you some useful links or examples of how I could do it?
Thanks in advance,
Fran

[dany_dev]

I suppose that you are able to do a query, and you miss only how create a table with SQL.

CREATE TABLE "table_name"
("column 1" "data_type_for_column_1",
"column 2" "data_type_for_column_2",
... )

SQL CREATE TABLE Statement

[iOSDeveloperz]

Originally Posted by franium

Hi all,
I have to add programmatically two tables to a sqlite3 database.
Have you some useful links or examples of how I could do it?
Thanks in advance,
Fran

-(void) createTableNamed:(NSString *) tableName withField1:(NSString *) field1 withField2:(NSString *) field2 {
char *err; 
NSString *sql = [NSString stringWithFormat:@"CREATE TABLE IF NOT EXISTS '%@' ('%@' TEXT PRIMARY KEY, '%@' TEXT);", tableName, field1, field2];
if (sqlite3_exec(db, [sql UTF8String], NULL, NULL, &err) != SQLITE_OK) { 
sqlite3_close(db);
 NSAssert(0, @"Table failed to create.");
}
}

Here db is an object of type sqlite3

[franium]

Originally Posted by iOSDeveloperz

-(void) createTableNamed:(NSString *) tableName withField1:(NSString *) field1 withField2:(NSString *) field2 {
char *err; 
NSString *sql = [NSString stringWithFormat:@"CREATE TABLE IF NOT EXISTS '%@' ('%@' TEXT PRIMARY KEY, '%@' TEXT);", tableName, field1, field2];
if (sqlite3_exec(db, [sql UTF8String], NULL, NULL, &err) != SQLITE_OK) { 
sqlite3_close(db);
 NSAssert(0, @"Table failed to create.");
}
}

Here db is an object of type sqlite3

Thanks.
Do you the difference in using sqlite3_exec instead of sqlite3_prepare_v2? I've no the ideas very clear on this point.

[dany_dev]

One-Step Query Execution Interface

The sqlite3_exec() interface is a convenience wrapper around sqlite3_prepare_v2(), sqlite3_step(), and sqlite3_finalize(), that allows an application to run multiple statements of SQL without having to use a lot of C code.

[franium]

Originally Posted by dany_dev

One-Step Query Execution Interface

Thank you.
I'll do some tries.