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.
>
Are you using Windows and the WIN API? If so you can just set up
callbacks to do it.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
