[Gambas-user] MySQL question

[Ron Onstenk]

On Thursday 10 August 2006 22:31, Charlie Reinl wrote:
> Salut Jim,
> 
> to make your list of all these tables, you can use 
> 
> For each cTable in Handle.Tables  
> 
> you can find some code in gambas-database-manager 
> CConnection / Sub Refesh
> 
> Amicalment
> Charlie
> 
> 
Hi Charlie,

Like this?

private asTables as string[]

PUBLIC SUB GetTables()
  DIM hTable AS Table
  asTables.Clear 
  FOR EACH hTable IN hConn.Tables
    asTables.Add(hTable.Name)
  NEXT
  asTables.Sort
END

' honnest stolen idea from? yes the gambas-database-manager :)
Was RefreshTables

Ron













> Am Donnerstag, den 10.08.2006, 15:17 +0200 schrieb James Hatridge:
> > Hi all..
> > 
> > I have a database named "stamps" (I'm a stamp dealer), it has X number of 
> > tables (unknown before opening "stamps") with names like "US", "Germany", 
> > "Russia", and so on. How can I make a list so that the user can pick which 
> > table to use?
> > 
> > Thanks for your help!
> > 
> > JIM
> 
> 
> -------------------------------------------------------------------------
> Using Tomcat but need to do more? Need to support web services, security?
> Get stuff done quickly with pre-integrated technology to make your job easier
> Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
> _______________________________________________
> Gambas-user mailing list
> Gambas-user at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/gambas-user
> 

-- 
The only bug free software from MickySoft is 
still shrink-wrapped in their warehouse...