Without gooding into much detail, there is a table that holds that
information.

Just take my example as a way of showing a deficiency with the
database that needs to fixed for everyone's benefit.

Thanks

--- In firebird-support@yahoogroups.com, Kjell Rilbe
<kjell.rilbe@a...> wrote:

> buppcpp wrote:
> > I don't have the liberty to change code just to fit Firebird.
> > The application has developers around the country, all doing

their

> > part. Also the application will be designed to work with

different

> > databases.
> >
> > The change should be to fix the database so that not only will I
> > benefit from it, so will you and every other new developer to FB.
>
> No objections there, but having a separate lookup table for the

value

> set of store_no is good DB design no matter what DB engine you

use. You

> shoud submit a change request (or whatever you choose to call it)

to

> your developer team.
>
> Kjell
> --
> --------------------------------------
> Kjell Rilbe
> Adressmarknaden AM AB
> E-post: kjell.rilbe@a...
> Telefon: 08-761 06 55
> Mobil: 0733-44 24 64