Re: Triggers and default values problem

What am I missing here? If you gave your field a default value and now you don't want it then take it out.

"Charles Bosquet" <cbosquet_at_free.fr> wrote in message news:carx5.949$F85.1278003_at_nnrp5.proxad.net...
> Hi,
>
> I have a table where MyField is a varchar2 with a default value = 'DEFAULT
> VALUE' :
> MyTable(..., MyField, ...)
>
> I have a trigger on MyTable on Before Insert :
> MyTrigger
>
> In my trigger i want to test if MyField is NULL when users insert rows in
> MyTable. But when i read :NEW.MyField, the field is never NULL because i
> give it a default value !!!
> I 'd like to give a default value to MyField and to know when it's NULL on
> before insert too ...
>
> Charles Bosquet APISoft FRANCE
>
>
>
Received on Mon Sep 18 2000 - 19:44:31 CDT