Again, thank you for your advice.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
On Thu, 26 Dec 2013 11:59:10 +, dean gwilliam
wrote:
>Thank you all for your helpful advice.
An alternative is PRAGMA table_info(yourtable);
http://sqlite.org/pragma.html#pragma_table_info
It resturns a result set, one row per column in yourtable.
--
Groet, Cordialement, Pozdrawiam, Reg
Thank you all for your helpful advice.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
This is actually awesome to know, thanks Stephen, I always thought at least 1 step is needed - I'm going to immediately implement
this in some functions!
On 2013/12/26 13:30, Stephan Beal wrote:
There are probably a few approaches that would work, but I can think of
none quicker/more efficien
On Thu, Dec 26, 2013 at 12:21 PM, RSmith wrote:
> There are probably a few approaches that would work, but I can think of
> none quicker/more efficient than maintaining a list of column names
> ("SELECT * from t WHERE 1 LIMIT 1" will produce it real quick)
If you want JUST the column names, you
A field name is an identifier, not just a string, so mostly it can be done in a direct SQL statement since the very idea of a select
is that you must at least know what you are selecting for...
That said, in MySQL / PostGres (for instance) can query the schema tables where a list of all fields a
On Dec 26, 2013, at 11:49 AM, dean gwilliam wrote:
> ...is this possible or should I return the whole lot and subject it to a
> regexp filter to get my cut-down list?
http://www.sqlite.org/lang_expr.html#like
___
sqlite-users mailing list
sqlite-use
...is this possible or should I return the whole lot and subject it to a
regexp filter to get my cut-down list?
Any advice much appreciated and BTWmerry Christmas to you all!
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:80
8 matches
Mail list logo