Re: [sqlite] sqlite problem - field names missing in select

2018-02-23 Thread Brian Curley
now that is awesome... Of course, I first attempted it on SQLiteStudio using its 3.15 version of sqlite. Looks like it missed it by one major release level; documentation says it arrived as of 3.16. I've tried it on my CLI version, which is 3.19+. Good stuff. Thanks, Simon. Regards. Brian P

Re: [sqlite] sqlite problem - field names missing in select

2018-02-23 Thread Simon Slavin
On 23 Feb 2018, at 6:28pm, Brian Curley wrote: > If there's pragmas like table_info available...can these be made available > for parsing, or used as virtual tables for selection, etc? In current versions of SQLite, you can use the results of PRAGMAs as if they are tables.

Re: [sqlite] sqlite problem - field names missing in select

2018-02-23 Thread Brian Curley
Not exactly sure of the OP's full issue. This does arise on occasion though, especially for when you try to maintain a self-sustaining database. Ignoring the API for a moment, there is some rationale for keeping metadata available for use. My primary use is as a CLI toolkit, if not as a desktop

Re: [sqlite] sqlite problem - field names missing in select

2018-02-23 Thread R Smith
On 2018/02/23 2:46 PM, M wrote: sqlite has an integral problem, field names cannot be selected each one inside a program, there is way to do it, but it is not straight and complicates the software programs, and makes the program complicated and not readble. when you try to do something with

Re: [sqlite] sqlite problem - field names missing in select

2018-02-23 Thread J Decker
https://sqlite.org/c3ref/column_name.html You can get the column names. On Fri, Feb 23, 2018 at 4:46 AM, M wrote: > sqlite has an integral problem, field names cannot be selected each one > inside a program, there is way to do it, but it is not straight and >

[sqlite] sqlite problem - field names missing in select

2018-02-23 Thread M
sqlite has an integral problem, field names cannot be selected each one inside a program, there is way to do it, but it is not straight and complicates the software programs, and makes the program complicated and not readble. when you try to do something with the selected fields/columns, a