[Gambas-user] MySQL question

[James Hatridge]

Hi Marco et al...

This is a good idea! I'll give it a try.

Thanks,

JIM
On Thursday 10 August 2006 20:16, Marco Gusy wrote:
> 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 at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/gambas-user

-- 
Jim Hatridge
Linux User #88484
------------------------------------------------------     
              WartHog Bulletin
          Info about new German Stamps
   http://www.fuzzybunnymilitia.org/~hatridge/bulletin/index.php

            Viel Feind -- Viel Ehr'
      Anti-US Propaganda stamp collection
  http://www.fuzzybunnymilitia.org/~hatridge/collection/index.php