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?


Regards,

Nols Smit





[Non-text portions of this message have been removed]