[Gambas-user] Sqlite and Gambas

[nando]

In mySQL you would do the following SQL (I do not know specifics of sqlite)
'SHOW TABLES;'   returns a record set of table names
'EXPLAIN table1;'  return a record set that explains table named table1
-Fernando

---------- Original Message -----------
From: andy60 <kaoticus60 at ...151...>
To: gambas-user at lists.sourceforge.net
Sent: Sat, 02 Feb 2008 12:28:23 +0100
Subject: [Gambas-user] Sqlite  and Gambas

> I don't understand the way to list tables of a sqlite database. For 
> example, it would be useful to list all the database tables in a 
> listbox.   How to use Connection.tables? Conenction.tables returns a 
> virtual <cid:part1.05060509.05070607 at ...151...> collection used for 
> managing the tables of the database.
> 
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Microsoft
> Defy all challenges. Microsoft(R) Visual Studio 2008.
> http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
> _______________________________________________
> Gambas-user mailing list
> Gambas-user at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/gambas-user
------- End of Original Message -------