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 Cu
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. See the "PRAGMA func
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 wo
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
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
> complicates the software program
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 lot
6 matches
Mail list logo