I didn't say I knew how you to do it in SQLitespeed, I said you your
use-case was very likely the same as mine.
I did notice the new keyword API and will move to 3.24 so I can use that.
Will look further into using explain to solve this problem, but guess the
output of explain may change in future
On 2018/08/01 5:56 PM, Bart Smissaert wrote:
May I ask about your use-case and what specifically is needed?
Probably exactly the same as you are using in your SQLitespeed app.
There is a SQL text box and the user can type anything in there he/she
wants.
App then needs to determine how to handle
do it?
>
>
>
> -Original Message-
> From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org]
> On Behalf Of Bart Smissaert
> Sent: Wednesday, August 01, 2018 11:56 AM
> To: SQLite mailing list
> Subject: Re: [sqlite] [EXTERNAL] Re: Is pragma index_list
: Is pragma index_list without supplied
table name valid SQL?
> May I ask about your use-case and what specifically is needed?
Probably exactly the same as you are using in your SQLitespeed app.
There is a SQL text box and the user can type anything in there he/she
wants.
App then needs to determine
> May I ask about your use-case and what specifically is needed?
Probably exactly the same as you are using in your SQLitespeed app.
There is a SQL text box and the user can type anything in there he/she
wants.
App then needs to determine how to handle that string:
Produce data to show, run a
On 2018/08/01 4:50 PM, Bart Smissaert wrote:
I think you might be right there, but for my practical purpose I need the
result to be invalid.
I just wonder if a Halt at row 2 and no further rows produced is good way
to determine this.
Such a hard question to answer. It's like asking if a
addr opcode p1p2p3p4 p5 comment
> - - -- -
> 0 Init 0 1 0 00 Start at 1
> 1 Halt 0 0 0 00
>
> sqlite> p
rom: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On
Behalf Of Bart Smissaert
Sent: Wednesday, August 01, 2018 10:50 AM
To: SQLite mailing list
Subject: Re: [sqlite] [EXTERNAL] Re: Is pragma index_list without supplied
table name valid SQL?
I think you might be right there, but
gt; 4 Halt 0 0 000 NULL
>
> -Ursprüngliche Nachricht-
> Von: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org]
> Im Auftrag von David Raymond
> Gesendet: Mittwoch, 01. August 2018 16:31
> An: SQLite mailing list
> Be
0 000 NULL
-Ursprüngliche Nachricht-
Von: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] Im
Auftrag von David Raymond
Gesendet: Mittwoch, 01. August 2018 16:31
An: SQLite mailing list
Betreff: [EXTERNAL] Re: [sqlite] Is pragma index_list without supplied
10 matches
Mail list logo