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