Re: [sqlite] Does an sqlite3_get_table() results set get updated.

2008-03-11 Thread Scott Hess
On Tue, Mar 11, 2008 at 1:30 PM, Neville Franks <[EMAIL PROTECTED]> wrote: > Wednesday, March 12, 2008, 3:50:46 AM, you wrote: > SH> On Mon, Mar 10, 2008 at 6:15 PM, Neville Franks <[EMAIL PROTECTED]> > wrote: > >> I'm displaying tree's which are built from SQL queries and I ideally > >>

Re: [sqlite] Does an sqlite3_get_table() results set get updated.

2008-03-11 Thread Neville Franks
Tuesday, March 11, 2008, 12:34:02 PM, you wrote: JS> Neville Franks wrote: >> Hi John, >> >> Tuesday, March 11, 2008, 11:51:57 AM, you wrote: >> >> JS> Neville Franks wrote: >> Hi John, Tuesday, March 11, 2008, 10:18:30 AM, you wrote: JS> Neville Franks wrote:

Re: [sqlite] Does an sqlite3_get_table() results set get updated.

2008-03-11 Thread Scott Hess
On Mon, Mar 10, 2008 at 6:15 PM, Neville Franks <[EMAIL PROTECTED]> wrote: > I'm displaying tree's which are built from SQL queries and I ideally > want the tree control to reflect updates to the underlying tables > without have to do queries all over again and rebuild the trees from >

Re: [sqlite] Does an sqlite3_get_table() results set get updated.

2008-03-10 Thread John Stanton
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

Re: [sqlite] Does an sqlite3_get_table() results set get updated.

2008-03-10 Thread Neville Franks
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

Re: [sqlite] Does an sqlite3_get_table() results set get updated.

2008-03-10 Thread John Stanton
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

Re: [sqlite] Does an sqlite3_get_table() results set get updated.

2008-03-10 Thread Jay A. Kreibich
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

[sqlite] Does an sqlite3_get_table() results set get updated.

2008-03-10 Thread Neville Franks
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