Neville Franks wrote: > 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"? > No. If you have the data in some form of windows control like a listview when you get a notify messge telling you it is changed you can fire a callback to perform an Sqlite update. It is a bit tedious to program. It is quite a while since I wrote such a program so I can only give you a big picture.
By making the edit phase a transaction you can give the user the option of commiting changes or rolling back. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users