[sqlite] sqlite3_prepare_v2 and std::string using SQLite 3.7.5 - BUG or me?

2011-03-01 Thread pcunite
Maybe I am to sleepy, but sqlite3_prepare_v2 is not accepting a std::string as a parameter in the following example: // Setup table structure SQLiteCommand("CREATE TABLE IF NOT EXISTS USR_EVENTS(AID INTEGER PRIMARY KEY AUTOINCREMENT,USER_ID BIGINT,GROUP_ID BIGINT,SIS_EVENTS_PTR BIGINT");

Re: [sqlite] sqlite3_prepare_v2 and std::string using SQLite 3.7.5 - BUG or me?

2011-03-01 Thread pcunite
> Your examples suggest that actually sqlite3-bind_text "is not > accepting std::string", not sqlite3_prepare_v2. But how exactly it > "doesn't accept"? You pass SQLITE_STATIC as 5th parameter there; are you sure > you don't destroy or change your strings before statement is executed? Correct, it

Re: [sqlite] sqlite3_prepare_v2 and std::string using SQLite 3.7.5 - BUG or me?

2011-03-01 Thread pcunite
UPDATE - Problem solved ! I found the error. I am so sorry, I try to test and be a helpful member... :( I was calling sqlite3_prepare_v2() twice and it was canceling out everything apparently. I am building these queries on the fly so I just missed that. How this happend was because when building