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 am having a bit of difficulty understanding your question, but get the
impression your parsing the DDL that created the table. If I am right you
will want to look at the PRAGMA statements to query the database schema.
Kind regards
Hans
Thank you for your reply,
Yes I do parse the DDL for a table and for a view, is there a pragma to
list the table list in a view
for instance :
CREATE VIEW CP_POINTNET as SELECT a.recid,b.ville FROM PointNet a, CP b
where a.cp = b.CODEPOSTE;
I would like to have :
1-PointNet
2-CP
without parsing the DDL
regards,
--
Noël Frankinet
Gistek Software SA
http://www.gistek.net
