Re: [sqlite] How to get all SQL statement syntax images?

2018-09-03 Thread Simon Slavin
On 4 Sep 2018, at 5:02am, Rocky Ji wrote: > I found the solutions to my issue, thanks everyone. Well done. > How do I mark this > thread [SOLVED] It's just email, so I think you did. Simon. ___ sqlite-users mailing list

Re: [sqlite] How to get all SQL statement syntax images?

2018-09-03 Thread Rocky Ji
I found the solutions to my issue, thanks everyone. How do I mark this thread [SOLVED] On Mon, Sep 3, 2018, 7:21 AM Warren Young wrote: > On Sep 2, 2018, at 4:15 AM, Richard Hipp wrote: > > > > On 9/1/18, Rocky Ji wrote: > >> Hi everyone, > >> > >> (Mailing list newbie here). Where can I get

[sqlite] Android Issue Loading Pre-compiled Binaries

2018-09-03 Thread David White
I have someone with an Android 8, arm64-v8a device testing a new Android app which uses the precompiled Sqlite binaries for Android. It appears there is some issue in loading the library. In the Android app log I see: 08-29 15:27:49.006 F/DEBUG (9478): #07 pc 00334204

[sqlite] Latest Pre-Compiled Android Binaries

2018-09-03 Thread David White
Hello and thanks for any help with this. I have been using the pre-compiled Android binaries on the download page for some time. Recently one of my apps had a "missing class" problem and I thought it might be due to the Sqlite libraries I had been using. These were dated 12/9/2017 and I saw

Re: [sqlite] [EXTERNAL] Missing function sqlite3_column_index

2018-09-03 Thread Simon Slavin
On 3 Sep 2018, at 6:15pm, Sebastian wrote: > So is this the reason that the function doesn't exist? That it needs AS > clauses to be useful? More likely, that it is not needed by SQLite itself. sqlite3_column_name() is used inside SQLite, but there's no need for your proposed function.

Re: [sqlite] [EXTERNAL] Missing function sqlite3_column_index

2018-09-03 Thread Sebastian
I am aware that this function would only work reliably if you use AS clauses. But that's what I intend to do, so no problem. Sorry for not having mentioned that. So is this the reason that the function doesn't exist? That it needs AS clauses to be useful? Or the efficiency pitfall I suspected?

Re: [sqlite] Problems with compiling SQLite for MUSL.

2018-09-03 Thread John Found
On Sun, 02 Sep 2018 22:25:16 -0600 "Keith Medcalf" wrote: > Interesting ... Sounds like the optimizer in the compiler is broken ... > unless someone has ideas about how to debug this. Can you compile with no > optimization and SQLITE_DEBUG defined and see what happens? Though, to me it >

Re: [sqlite] [EXTERNAL] Missing function sqlite3_column_index

2018-09-03 Thread Hick Gunter
The name of an output column is not even defined, much less unique, unless the author of the statement has done extra work (using unique column names and/or AS clauses). Consider Select a.*,b.*,c.* ... Where each table has a column named Id. Which index would you like to have returned?

Re: [sqlite] [EXTERNAL] .exit in script is not working

2018-09-03 Thread Hick Gunter
Try the following script: Select "statement"; .exit Select "after exit"; Running the script as an init file produces only the first text. An .exit command in an init file will only terminate the execution of the init file itself, not the sqlite shell as a whole. This is intended.