Re: [sqlite] [EXTERNAL] Help with sqlite3TreeViewSelect

2019-07-30 Thread x
, 2019 7:07:15 PM To: SQLite mailing list Subject: Re: [sqlite] [EXTERNAL] Help with sqlite3TreeViewSelect On 29 Jul 2019, at 5:44pm, x wrote: > It’s not as easy to get access to sqlite3TreeViewSelect on windows as it > would appear to be in the unix debugger. When I did find out how to

Re: [sqlite] [EXTERNAL] Help with sqlite3TreeViewSelect

2019-07-29 Thread Simon Slavin
On 29 Jul 2019, at 5:44pm, x wrote: > It’s not as easy to get access to sqlite3TreeViewSelect on windows as it > would appear to be in the unix debugger. When I did find out how to access it > I noticed it returned a string that would enable me to do away with reams of > code I wrote to do

Re: [sqlite] [EXTERNAL] Help with sqlite3TreeViewSelect

2019-07-29 Thread x
To: SQLite mailing list Subject: Re: [sqlite] [EXTERNAL] Help with sqlite3TreeViewSelect On 7/29/19, Hick Gunter wrote: > Qquestions about which internal > representation ... is something only the developers would > be able to divulge, The internal representation and t

Re: [sqlite] [EXTERNAL] Help with sqlite3TreeViewSelect

2019-07-29 Thread Richard Hipp
On 7/29/19, Hick Gunter wrote: > Qquestions about which internal > representation ... is something only the developers would > be able to divulge, The internal representation and the output of sqlite3TreeViewSelect() are emphatically not APIs. Both are undocumented and both can and do change

Re: [sqlite] [EXTERNAL] Help with sqlite3TreeViewSelect

2019-07-29 Thread Hick Gunter
to divulge, given willingness to do so. -Ursprüngliche Nachricht- Von: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] Im Auftrag von x Gesendet: Montag, 29. Juli 2019 12:19 An: SQLite mailing list Betreff: Re: [sqlite] [EXTERNAL] Help with sqlite3TreeViewSelect I’m still

Re: [sqlite] [EXTERNAL] Help with sqlite3TreeViewSelect

2019-07-29 Thread x
. From: sqlite-users on behalf of Hick Gunter Sent: Monday, July 29, 2019 10:53:02 AM To: 'SQLite mailing list' Subject: Re: [sqlite] [EXTERNAL] Help with sqlite3TreeViewSelect Let's go back to your example statement with your join of two tables. select b,c from

Re: [sqlite] [EXTERNAL] Help with sqlite3TreeViewSelect

2019-07-29 Thread Hick Gunter
ot;Well, I asked for permission to pray while smoking." -Ursprüngliche Nachricht- Von: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] Im Auftrag von x Gesendet: Montag, 29. Juli 2019 11:09 An: SQLite mailing list Betreff: Re: [sqlite] [EXTERNAL] Help with sqlite3Tre

Re: [sqlite] [EXTERNAL] Help with sqlite3TreeViewSelect

2019-07-29 Thread x
te-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] Im Auftrag von x Gesendet: Montag, 29. Juli 2019 10:05 An: SQLite mailing list Betreff: Re: [sqlite] [EXTERNAL] Help with sqlite3TreeViewSelect >>Your implicit claim is "not all instances of column reference are reported to &

Re: [sqlite] [EXTERNAL] Help with sqlite3TreeViewSelect

2019-07-29 Thread Hick Gunter
first*"? -Ursprüngliche Nachricht- Von: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] Im Auftrag von x Gesendet: Montag, 29. Juli 2019 10:05 An: SQLite mailing list Betreff: Re: [sqlite] [EXTERNAL] Help with sqlite3TreeViewSelect >>Your implicit claim is "not al

Re: [sqlite] [EXTERNAL] Help with sqlite3TreeViewSelect

2019-07-29 Thread x
>>Your implicit claim is "not all instances of column reference are reported to >>the authorizer, notably those inside a USING clause That and you’ve got to anticipate the order they’re sent to the callback in. ___ sqlite-users mailing list

Re: [sqlite] [EXTERNAL] Help with sqlite3TreeViewSelect

2019-07-29 Thread Hick Gunter
lause". -Ursprüngliche Nachricht- Von: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] Im Auftrag von x Gesendet: Sonntag, 28. Juli 2019 13:49 An: SQLite mailing list Betreff: Re: [sqlite] [EXTERNAL] Help with sqlite3TreeViewSelect The following simple exa

Re: [sqlite] [EXTERNAL] Help with sqlite3TreeViewSelect

2019-07-28 Thread x
The following simple example might illustrate what I’m trying to achieve CREATE TABLE tbl0 (a INTEGER PRIMARY KEY, b INTEGER); CREATE TABLE tbl1 (a INTEGER PRIMARY KEY, c INTEGER); Suppose a user enters the following sql SELECT b, c FROM tbl0 INNER JOIN tbl1 USING (a) WHERE a > ?1; I want to

Re: [sqlite] [EXTERNAL] Help with sqlite3TreeViewSelect

2019-07-28 Thread x
eliver a row. -Ursprüngliche Nachricht- Von: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] Im Auftrag von x Gesendet: Samstag, 27. Juli 2019 14:08 An: SQLite mailing list Betreff: [EXTERNAL] [sqlite] Help with sqlite3TreeViewSelect g the lin I’ve been using this while debugging

Re: [sqlite] [EXTERNAL] Help with sqlite3TreeViewSelect

2019-07-28 Thread Hick Gunter
- Von: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] Im Auftrag von x Gesendet: Samstag, 27. Juli 2019 14:08 An: SQLite mailing list Betreff: [EXTERNAL] [sqlite] Help with sqlite3TreeViewSelect I’ve been using this while debugging by inserting the following code just before