Re: Check box in Oracle Forms

[Quoted] You have to set the following checkbox properties, because it relates to a not null column:

required = yes
[Quoted] initial value = Y or N (you choose)

good luck,

Robert

"fororacleonly" <fororacleonly_at_yahoo.com> schreef in bericht news:9da6aa86.0309121032.2d8be93f_at_posting.google.com...
> create table t ( x varchar2(1) not null default 'N')
> I have a check constraint on column x restricting values to ('Y','N')
>
> On my form I have have a chek box for the above column. I havent set
> the initial value for the check box. The checked value is 'Y' and the
> unchecked value is 'N'.
>
> When I'm doing a insert from my form, I'm getting the error message
> stating cannot insert null into X.
>
> According to me, the default value should apply and the record should
> save.
>
> I'm I missing something, like setting a check box property etc.
>
> Please give your opinion.
Received on Fri Sep 12 2003 - 21:44:11 CEST