Arbol One <arbol...@programmer.net> wrote: > rc = sqlite3_open_v2(dbName.c_str(), &db, SQLITE_OPEN_READWRITE | > SQLITE_OPEN_CREATE, vfs.data());
Just pass NULL for the last parameter. There is very rarely a need to pass anything else. > *//2 . ) create a table > std::string create_table("CREATE TABLE friend (name TEXT, address TEXT, age > INT)"); > rc = sqlite3_prepare_v2( > &db, /* Database handle */ Drop the ampersand. Note that, while sqlite3_open_v2 takes sqlite3** (two stars), sqlite3_prepare_v2 wants sqlite3* (one star). > creat_table.c_str() , /* SQL statement, UTF-8 encoded */ > ??, /* Maximum length of zSql in bytes. */ You can pass creat_table.length(), or simply pass -1 and have SQLite accept all characters up to the terminating NUL. > ??, /* OUT: Statement handle */ Same story as with sqlite3_open_v2 and DB handle. You declare a variable like "sqlite3_stmt* stmt;", then pass &stmt. > ?? /* OUT: Pointer to unused portion of zSql */ Just pass NULL. This is used when you have a single string containing multiple statements. Note that sqlite3_prepare_v2 only prepares the statement, but doesn't actually execute it. To run the statement, you would call sqlite3_step. After you are done, call sqlite3_finalize to free resources associated with the statement; and sqlite3_close to close your database connection. -- Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users