how to create table in sqlite data base programmatically in iPhone

if (sqlite3_open(dbpath, &amp;myDB) == SQLITE_OK) {

        NSString *charsTableNameQuery = [NSString stringWithFormat:@"CREATE TABLE IF NOT EXISTS %@(id INTEGER PRIMARY KEY, charName TEXT)",charsTableName];

        int results = 0;

        //create all chars tables
        const char *charsTableNameQuerySQL = [charsTableNameQuery UTF8String];
        sqlite3_stmt * charsTableNameStatment = nil;
        results = sqlite3_exec(myDB, charsTableNameQuerySQL, NULL, NULL, NULL);
        if (results != SQLITE_DONE) {
            const char *err = sqlite3_errmsg(tekkenDB);
            NSString *errMsg = [NSString stringWithFormat:@"%s",err];
            if (![errMsg isEqualToString:@"not an error"]) {
                NSLog(@"createTables-chartables error: %@",errMsg);
                return FALSE;
            }
        }

        sqlite3_finalize(charsTableNameStatment);
        sqlite3_close(myDB);

if (sqlite3_open(dbpath, &myDB) == SQLITE_OK) {

NSString *charsTableNameQuery = [NSString stringWithFormat:@"CREATE TABLE IF NOT EXISTS %@(id INTEGER PRIMARY KEY, charName TEXT)",charsTableName];

int results = 0;

//create all chars tables

const char *charsTableNameQuerySQL = [charsTableNameQuery UTF8String];

sqlite3_stmt * charsTableNameStatment = nil;

results = sqlite3_exec(myDB, charsTableNameQuerySQL, NULL, NULL, NULL);

if (results != SQLITE_DONE) {

const char *err = sqlite3_errmsg(tekkenDB);

NSString *errMsg = [NSString stringWithFormat:@"%s",err];

if (![errMsg isEqualToString:@"not an error"]) {

NSLog(@"createTables-chartables error: %@",errMsg);

return FALSE;

}

sqlite3_finalize(charsTableNameStatment);

sqlite3_close(myDB);

Related Posts

Swift Programming Language Interview Questions And Answers-2

Swift Technical Interview Questions and Answers !

Steps to reviewing your codes in IOS !