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@...
Telefon: 08-761 06 55
Mobil: 0733-44 24 64