Dennis Cote wrote:
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
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
Dennis Cote wrote:
Noel Frankinet wrote:
Lawrence Chitty wrote:
You may be able to do this using the 'explain' statement
for example, I have a view called 'myview'. Wrapping this into an
sql select statement and proceeding this with explain e.g.
> explain select null from myview
gives a
Dennis Cote wrote:
Noel Frankinet wrote:
Lawrence Chitty wrote:
You may be able to do this using the 'explain' statement
for example, I have a view called 'myview'. Wrapping this into an
sql select statement and proceeding this with explain e.g.
> explain select null from myview
gives a
Noel Frankinet wrote:
Lawrence Chitty wrote:
You may be able to do this using the 'explain' statement
for example, I have a view called 'myview'. Wrapping this into an sql
select statement and proceeding this with explain e.g.
> explain select null from myview
gives a result set with the
Lawrence Chitty wrote:
Noel Frankinet wrote:
Hello,
Is there a better way to list all table making a view than parsing
SQL. Is there an API ?
You may be able to do this using the 'explain' statement
for example, I have a view called 'myview'. Wrapping this into an sql
select statement a
Noel Frankinet wrote:
Hello,
Is there a better way to list all table making a view than parsing
SQL. Is there an API ?
You may be able to do this using the 'explain' statement
for example, I have a view called 'myview'. Wrapping this into an sql
select statement and proceeding this with ex
Hans Bieshaar wrote:
Noël Frankinet wrote:
>Is there a better way to list all table making a view than parsing SQL.
>Is there an API ?
>I would like to show all table in a view (in a tree-view gadget).
>Same question for the table schema, I do parse the SQL but its rather
>fragile.
I
are you looking for something like
select * from sqlite_master;
?
bye, peter
Noel Frankinet wrote:
Hello,
Is there a better way to list all table making a view than parsing SQL.
Is there an API ?
I would like to show all table in a view (in a tree-view gadget).
Same question for the table s
Noël Frankinet wrote:
>Is there a better way to list all table making a view than parsing SQL.
>Is there an API ?
>I would like to show all table in a view (in a tree-view gadget).
>Same question for the table schema, I do parse the SQL but its rather
>fragile.
I am having a bit of di
Hello,
Is there a better way to list all table making a view than parsing SQL.
Is there an API ?
I would like to show all table in a view (in a tree-view gadget).
Same question for the table schema, I do parse the SQL but its rather
fragile.
I'm still in 2.8
Thank you.
--
Noël Frankinet
Gis
11 matches
Mail list logo