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
nece
g von Chris Locke
> Gesendet: Donnerstag, 21. Juli 2016 23:20
> An: SQLite mailing list
> Betreff: [sqlite] [System.Data.SQLite.DLL] Retrieving table names with
> column names
>
> I've a table I'm calling recursively.
>
> CREATE TABLE "staff" ( `id` TE
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 bet
nerstag, 21. Juli 2016 23:20
An: SQLite mailing list
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, `surname`
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 simpl
5 matches
Mail list logo