Jens Alfke asks:
>Maybe pass the column name as a string, i.e. `attr('H',3)`
2 problems with that idea. First, the first argument has to refer to a value in
the virtual table in order to invoke the overridden version (overrides are per
table, so I use the ppArg to bind function invocation to ass
> On Feb 13, 2020, at 12:52 PM, David Jones wrote:
>
> sqlite> select F,G,H,attr(H,3) from summary; # show formula used
> to calculate column H.
Maybe pass the column name as a string, i.e. `attr('H',3)`? It sounds like your
`attr` function needs to know the _identity_ of the col
I’ve written a virtual table to view spreadsheet data inside Excel workbook
(.xlsx) files as SQlite tables. I want to implement an SQL function, attr(),
which the virtual table overrides to give access to the raw attributes of the
cell being returned. I’m looking for a robust way to find the act
3 matches
Mail list logo
