My friend, heavens awaits you. Outstanding! Thanks man! -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Igor Tandetnik Sent: Monday, June 25, 2012 7:32 PM To: [email protected] Subject: Re: [sqlite] C++ - ISERT from a data object
Arbol One <[email protected]> wrote: > In my GUI application the user enters a information that will go in a > SQLite database table, so statements like: > > string dbdata = "INSERT INTO friend (name, address, age) VALUES > ('Caramba', > '490 New Bridge', '49')"; > > > > are not very useful in a real life C++ GUI application. I would > assume that SQLite has functions to submit information in the form of > string object to a table sqlite_stmt* stmt; sqlite3_prepare_v2(db, "insert into friend(name, address, age) values (?, ?, ?);", -1, &stmt, NULL); string name = "Caramba"; string address = "490 New Bridge"; int age = 49; sqlite3_bind_text(stmt, 1, name.c_str(), name.length(), SQLITE_STATIC); sqlite3_bind_text(stmt, 2, address.c_str(), address.length(), SQLITE_STATIC); sqlite3_bind_int(stmt, 3, age); sqlite3_step(stmt); sqlite3_finalize(stmt); -- Igor Tandetnik _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
