In looking at the reference http://www.sqlite.org/c3ref/free_table.html it states that the result is a pointer array that has (rows+1)*columns elements.
I pose a query to select items from my database table. The function returns a row value of 5 and column value of 19. This tells me that there should be 6*19 = 114 elements in the array of returned values. However, when I attempt to access the 21st or greater element in the array, I get an exception. When I look at the result in the debugger, it only shows 20 elements. Basically, the header row plus the first element in, what should be the first row of data returned. Here is the code I am using, I do not see anything wrong with it, but I can't access the returned results. The data base is opened properly, the query is "select * from table1". The code looks like this: int rc = sqlite3_get_table(db, query, &result, &nrow, &ncol, &errmsg); Why cannot I access the data beyond the header row? Thanks. -- View this message in context: http://www.nabble.com/Problem-using-sqlite3_get_table-in-C%2B%2B-tp25531319p25531319.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
