On Fri, Dec 2, 2016 at 6:56 PM, Igor Korot <ikoro...@gmail.com> wrote: > Hi, ALL, > I wrote following code in C++ (error checking removed for clarity): > > [code] > const std::wstring &SQLiteDatabase::GetTableComments(const > std::wstring &tableName, std::vector<std::wstring> &errorMsg) > { > std::wstring comment = L""; > sqlite3_stmt *stmt = NULL; > std::wstring errorMessage; > std::wstring query = L"SELECT \"abt_cmnt\" FROM \"sys.abcattbl\" > WHERE \"abt_tnam\" = ?;"; > int res = sqlite3_prepare_v2( m_db, > sqlite_pimpl->m_myconv.to_bytes( query.c_str() ).c_str(), > query.length(), &stmt, 0 ); > if( res == SQLITE_OK ) > { > res = sqlite3_bind_text( stmt, 1, > sqlite_pimpl->m_myconv.to_bytes( tableName.c_str() ).c_str(), -1, > SQLITE_STATIC ); > if( res == SQLITE_OK ) > { > res = sqlite3_step( stmt ); > if( res == SQLITE_ROW ) > { > comment = sqlite_pimpl->m_myconv.from_bytes( (const > char *) sqlite3_column_text( stmt, 0 ) ); > } > [/code] > > The trouble is that sqlite3_step() returns 101 (SQLITE_DONE) and not > 100 (SQLITE_ROW). > > Does anyone see an issue with this code:
Also just to clarify: std::wstring_convert<std::codecvt_utf8<wchar_t> > m_myconv; > > Thank you. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users