Lawrence Chitty wrote:
From what you explain above, would the following approach work to see
if NDEBUG defined.
> explain select null from sqlite_master.
Now look for the OpenRead and see if p3 is a number (NDEBUG not
defined) or 'sqlite_master' (NDEBUG defined). This is one table we
always know is always going to be present.
I only use the Windoze prebuilt tclsqlite.dll, which would appear to
have NDEBUG defined, so I can't really check this out any further.
Yes, that sounds like a perfectly valid test for a production build, and
hence whether or not you need to lookup the table names in the
sqlite_master table.
Note also that for some Views the OpenRead opcodes could be opening
indexes (rather than tables), but again you can identify them by looking
in the sqlite_master table.
HTH
Dennis Cote