Hi NG!

There is a table with a field SAMPLEDATE DATE NOT NULL and a trigger
BEFORE INSERT: IF (NEW.SAMPLEDATE is null) then
NEW.SAMPLEDATE=current_date

I set up a query and a grid, I want empty fields to be sent as null, as
I expect them to be converted by the trigger.

So I check: EMPTY AS NULL and COMPUTED in the fields.

IBO reads the NOT NULL constraint of the fields from the table and
obviously won't send NULL but 0. As a result I get a date from the
nineteenth century.

Is it a bug or a feature?

Rgds, Boris