Re: [sqlite] [System.Data.SQLite.DLL] Retrieving table names with column names

Thanks Ryan. I guess I'm used to MS Access (can I mention those words in this mailing list?) which recognised the 'table name.field name' convention on all columns regardless. It made things 'lazy' I guess. If a table has 20 fields, then it can be a pain listing out every field required. A

Re: [sqlite] [System.Data.SQLite.DLL] Retrieving table names with column names

.sqlite.org] Im Auftrag von Chris Locke > Gesendet: Donnerstag, 21. Juli 2016 23:20 > An: SQLite mailing list <sqlite-users@mailinglists.sqlite.org> > Betreff: [sqlite] [System.Data.SQLite.DLL] Retrieving table names with > column names > > I've a table I'm calling recursively. >

Re: [sqlite] [System.Data.SQLite.DLL] Retrieving table names with column names

On 2016/07/21 11:20 PM, Chris Locke wrote: I've a table I'm calling recursively. ... I know I can change my SQL statement to be explicit, and select each required field and use AS, but is that the only solution? It's not so much the "Only" way as it is the "Correct" way. Query planners

Re: [sqlite] [System.Data.SQLite.DLL] Retrieving table names with column names

ag, 21. Juli 2016 23:20 An: SQLite mailing list <sqlite-users@mailinglists.sqlite.org> Betreff: [sqlite] [System.Data.SQLite.DLL] Retrieving table names with column names I've a table I'm calling recursively. CREATE TABLE "staff" ( `id` TEXT, `logonName` TEXT, `firstname` TEXT,

[sqlite] [System.Data.SQLite.DLL] Retrieving table names with column names

I've a table I'm calling recursively. CREATE TABLE "staff" ( `id` TEXT, `logonName` TEXT, `firstname` TEXT, `surname` TEXT, `departmentId` TEXT, `managerId` TEXT, `holidayDaysEntitlement` INTEGER, `holidayDaysTaken` REAL, PRIMARY KEY(`id`) ) managerId points to the same table, so my join is