Hi John, Tuesday, March 11, 2008, 10:18:30 AM, you wrote:
JS> Neville Franks wrote: >> 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. >> JS> Are you using Windows and the WIN API? If so you can just set up JS> callbacks to do it. I am using C++ and Windows. Do you mean use "triggers"? -- Best regards, Neville Franks, http://www.surfulater.com http://blog.surfulater.com _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
