Re: What is a "code table"?

"Bob" <roberth_at_nospam.com> wrote:

>I've seen this term used many times, but never defined. Any searches for a
>definition only finds use of the term in passing.
>
>Do "code tables" contain actual uncompiled programming code , or other SQL?
>Is this good design? How do you change control if the guts of an
>application can be so easily changed? Any examples?

     a.k.a. "lookup table", as in:
          create table colours (colcode n(3), coldesc c(20));
          insert into colours (colcode,coldesc) values (1,"Black");
          insert into colours (colcode,coldesc) values (2,"Brown");
          insert into colours (colcode,coldesc) values (3,"Red");

Sincerely,

Gene Wirchenko

Computerese Irregular Verb Conjugation:

     I have preferences.
     You have biases.
     He/She has prejudices.