[sqlite] sql statement CREATE TABLE

[Arbol One]

I am getting a run time error that reads

=====

Error 1

Library routine out of sequence

=====

 

The only things, since I am new on it, that could be causing a problem would
be the sql statement CREATE TABLE, maybe the parameters are not right?

 

The code nip -----

 

sql_param_tblName = "CREATE TABLE name(n_id INTEGER PRIMARY KEY, title TEXT,
fname TEXT, mname TEXT, lname TEXT)";

rc = sqlite3_prepare_v2(  db,  sql_param_tblName.c_str() ,
sql_param_tblName.length(),  &stmt,   NULL);

    if(rc != SQLITE_OK) {

               /// Here is where the -Error 1- occurred 

 }

    rc = sqlite3_step(stmt);

 

    if(rc != SQLITE_DONE) {

        sqlite3_close(db);

        sqlite3_finalize(stmt);

        //Error

    }

    sqlite3_finalize(stmt);

}Freedom of speech does not translate to freedom of insulting

 

_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users