mardi 7 juillet 2015

How to read string from sqlite using sqlite3_prepare_v2()?

i have a sqlite3 database and i need to query on it using visual c++ 2013? i am using sqlite3.h for creating connection an manipulate database;

i am using this code to retraive data :

   sqlite3_stmt *stmt;
sqlite3_prepare_v2(db, "SELECT * FROM response where list_id =?", -1, &stmt, NULL);
sqlite3_bind_int(stmt, 1, *2*);
tree<SensorState>::iterator itr = sensorTree.begin(); 
for (;;)
{
    int rc = sqlite3_step(stmt);
    if (rc == SQLITE_DONE){
        break; 
    }
    else if (rc != SQLITE_ROW){
        cout << "error in reading sensore with error No: " << rc;
        break; 
    }
    const char* name = reinterpret_cast<const char*>(sqlite3_column_text(stmt, 2)); 
    int value = sqlite3_column_int(stmt, 3);
    cout << name->value <<endl;  
}

now in terminal i am getting this outbut: enter image description here

but it must show this output:

s1->5
s2->2
s4->2

how can i rea string correctly from sqlite3 using c++?

Aucun commentaire:

Enregistrer un commentaire