Re: HELP IM in need.

Can you add to the table new values if you have a constant set on it. Also can you do this for instance v_grade_type_code CONSTANT GRADE TYPE .grade_type_code%TYPE . Please let me know.

Thanks

"Jon Waterhouse" <jonwaterhouse_at_mail.gov.nf.ca> wrote in message news:3c14c87e.0_at_209.128.1.3...
> 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 - 12:20:34 CST