Tuesday, March 11, 2008, 8:48:05 AM, you wrote: JAK> On Tue, Mar 11, 2008 at 08:37:27AM +1100, Neville Franks scratched on the wall: >> If I use sqlite3_get_table() and update/insert/delete one of the tables >> in the original query, does the results set get updated. ie. If I >> iterate through the original results from sqlite3_get_table() will I >> see the changes, or do I need to run the sqlite3_get_table() query >> anew? >> >> If I do see the changes does this also apply to an sqlite3_get_table() >> query that was on a VIEW?
JAK> From <http://www.sqlite.org/c3ref/free_table.html>: JAK> The sqlite3_get_table() interface is implemented as a wrapper around JAK> sqlite3_exec(). The sqlite3_get_table() routine does not have access JAK> to any internal data structures of SQLite. It uses only the public JAK> interface defined here. As a consequence, errors that occur in the JAK> wrapper layer outside of the internal sqlite3_exec() call are not JAK> reflected in subsequent calls to sqlite3_errcode() or JAK> sqlite3_errmsg(). JAK> In other words, "No." You need to run it again. JAK> -j Jay, Thanks, I assumed that would be the case. Dynamically updating GUI's on SQL DB updates appears to be challenging. -- Best regards, Neville Franks, http://www.surfulater.com http://blog.surfulater.com _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
