[EMAIL PROTECTED] wrote:
On 2004-11-21, at 14.15, Antonio Coralles wrote: > how can i get the output which will be produced by sqlite>.tables from > a > sqlite_exec call inside my programm ? > (i'm using sqlite 2.8.14)
SELECT name FROM sqlite_master WHERE type='table' UNION ALL SELECT name FROM sqlite_temp_master WHERE type='table' ORDER BY name;
Is that what you need? :-)
yes, thanks very much !
Tomas Franzén Lighthead Software http://www.lightheadsw.com/
