If you have a list of valid values in another table, you can set a
CONSTRAINT that references that table. If you have a static list
('a",'B','C') for example, you canuse the CHECK attribute on the column.
KDankwah <kdankwah_at_aol.comnojunk> wrote in message
news:20011209214107.16657.00001531_at_mb-bj.aol.com...
> I have a table with only 2 fields which I am updating, I created an update
> procedure which compiled and its doing the update, but what I am finding
is
> that the database entry of grade_code which is one of the fields in the
table
> and a not null and a type code of CHAR, takes any entry when I am doing an
> update, even a number.
>
> Could someone please give me a syntax that will check the table to see if
the
> field grade_code exists in the table before doing the update. I will take
any
> suggestions.
>
>
> Thanks in advance
>
> Johnny
Received on Mon Dec 10 2001 - 08:38:05 CST
