Although I would like to make use of the "BLANK IS NULL" but if I
check it and do a Change, the blank field is not set to Null.

Other question about the GeneratorLinks property of the IBODatabase:
It seems a trigger is not needed if one set the value of the property
to:
Table1.ID=<name of generator>

Is it also normal for the generator to increment with one even if the
transaction is cancelled (Click on the DBNavigation's Insert and then
on Cancel).



Nols Smit

--- In IBObjects@yahoogroups.com, Helen Borrie <helebor@t...> wrote:
> At 03:41 PM 7/07/2005 +0200, you wrote:
> >Hi,
> >
> >I have the following FireBird table:
> >
> >/* Tables definitions */
> >CREATE TABLE TABLE1 (
> > ID INTEGER NOT NULL,
> > DESCRIPTION VARCHAR (30) CHARACTER SET WIN1251 COLLATE
WIN1251,
> > ADDRESS BLOB sub_type 1 segment size 1 NOT NULL);
> >/* Primary keys definition */
> >
> >ALTER TABLE TABLE1 ADD CONSTRAINT PK_TABLE1 PRIMARY KEY (ID);
> >
> >
> >
> >In my IBOQuery component, I edited it and set the following
> >ColumnAttributes for the DESCRIPTION field:
> >I checked BLANK IS NULL and unchecked REQUIRED
> >
> >I then clicked the prepare icon (light bulb)
> >
> >But when I run the program, I get the following error message when
I don't
> >supply a value for the DESCRIPTION field:
> >ISC ERROR MESSAGE:
> >validation error for column DESCRIPTION, value "*** nul ***"
> >
> >Why is IBOQuery ignoring the allowed null value of the table
column?
>
> Because you unchecked the "Required" property of the column, which
is NOT
> REQUIRED, causing it to become REQUIRED! It is already a nullable
column,
> so let sleeping dogs lie.
>
> Helen