buppcpp wrote:

> --- In firebird-support@yahoogroups.com, Kjell Rilbe
> <kjell.rilbe@a...> wrote:
>
>>buppcpp wrote:
>>>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.
>
> Without gooding into much detail, there is a table that holds that
> information.

You could have saved quite a lot of debate in this thread if you had
told us that from the start.

Just out of curiosity: why don't you (the application) query that table
instead?

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