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 are kept on a per table as a
standard select sub-query (with glob/like) list and then use that with IN to pick columns. Not in SQLite though, unless you can
parse the "create table".
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) then grep that into a list used for building the next
queries (SELECT ?1, ?2, etc.....) according to the list.
So to put that into English: Sorry, don't think you can do that, but good luck!
On 2013/12/26 12:49, 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?
Any advice much appreciated and BTW....merry Christmas to you all!
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
