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:
Thank you.
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
