[prev in list] [next in list] [prev in thread] [next in thread] 

List:       gambas-user
Subject:    Re: [Gambas-user] MySQL question
From:       Marco Gusy <picander78 () yahoo ! it>
Date:       2006-08-10 18:16:49
Message-ID: 200608102016.50294.picander78 () yahoo ! it
[Download RAW message or body]

Alle 15:17, giovedì 10 agosto 2006, James Hatridge ha scritto:
> 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

It's not the best Idea to create a table for each stamp nationality.
You should create a table wehre the first field contains stamps nationality, 
and the rest of fileds like the tables you want to index.

Then you can open a table with "Select * from stamps where nationality='US'; " 
and see the table as before.
To see a list of nationalities "Select distinct nationality from stamps;"

-------------------------------------------------------------------------
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@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/gambas-user

[prev in list] [next in list] [prev in thread] [next in thread]