On Wed, Feb 25, 2015 at 7:52 AM, Hick Gunter wrote:
> And the "explain" output will contain virtual table opcodes
>
I use this technique to discover which tables and virtual tables a view
accesses (instead of trying to parse the query.)
I execute "explain select rowid from $viewname", and look
olumn0 1 500 sgb_dd_draw.game_no
?
-Urspr?ngliche Nachricht-
Von: Evans, Randall [mailto:REvans at seasoft.com]
Gesendet: Dienstag, 24. Februar 2015 20:18
An: sqlite-users at mailinglists.sqlite.org
Betreff: Re: [sqlite] Using incremental BLOB funct
Thanks to Richard Hipp and Hick Gunter for their replies on this topic.
Given that support for support for BLOBs in virtual tables differs from that
for BLOBs in physical tables, is there any method or function available to the
sqlite3_x() caller that can be used to distinguish tables
?ngliche Nachricht-
Von: Evans, Randall [mailto:REvans at seasoft.com]
Gesendet: Dienstag, 24. Februar 2015 01:47
An: sqlite-users at mailinglists.sqlite.org
Betreff: [sqlite] Using incremental BLOB functions against a BLOB column in a
virtual table
Can the incremental BLOB functions
On 2/23/15, Evans, Randall wrote:
> Can the incremental BLOB functions (sqlite_blob_open(), sqlite_blob_read(),
> etc) access BLOB column data defined in a SQLite virtual table? If it
> matters, I am only interested in read-only access at this time.
no.
>
> If the answer is yes, is there any
Can the incremental BLOB functions (sqlite_blob_open(), sqlite_blob_read(),
etc) access BLOB column data defined in a SQLite virtual table? If it matters,
I am only interested in read-only access at this time.
If the answer is yes, is there any facility in virtual table support for
xColumn or
6 matches
Mail list logo