StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PORetrieve Sqlite table data in C++
text
Body
copied!<p>I have the code as below. I am trying to simply get data from a table i have already created. How do i get the data in the array p_fields that is defined in the callback function into a variable in main. Can i define a char ** array in main and copy the data somehow into it in the callback function?</p> <p>Thanks very much, Shyam.</p> <pre><code>#include <string.h> #include <stdio.h> #include "sqlite3.h" #include <iostream> #include <fstream> #include <sstream> using namespace std; sqlite3* db; int select_callback(void *p_data, int num_fields, char **p_fields, char **p_col_names) { int i; for(i=0; i < num_fields; i++) { if (p_fields[i]) { printf("%20s", p_fields[i]); } else { printf("%20s", " "); } } printf("\n"); return 0; } void select_stmt(const char* stmt) { char *errmsg; int ret; int nrecs = 0; float var; ret = sqlite3_exec(db, stmt, select_callback, &nrecs, &errmsg); if(ret!=SQLITE_OK) { printf("Error in select statement %s [%s].\n", stmt, errmsg); } else { printf("\n %d records returned.\n", nrecs); } cout<< ret << endl; } void sql_stmt(const char* stmt) { char *errmsg; int ret; ret = sqlite3_exec(db, stmt, 0, 0, &errmsg); if(ret != SQLITE_OK) { printf("Error in statement: %s [%s].\n", stmt, errmsg); } } int main() { sqlite3_open("Flamelet.db", &db); if(db == 0) { printf("\nCould not open database."); return 1; } sqlite3_stmt *stmt; select_stmt("SELECT density from Ftable where PROG=10.0"); sqlite3_close(db); return 0; } </code></pre>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload