I have a similar problem, which I have 'modified' by adding
a trigger to the database.

Added BEFORE UPDATE

With
IF ( NEW.ADD1 IS NULL THEN NEW.ADD1 = '';

for each line that I want to ensure has a blank entry rather
than NULL.

It is not nice, but it works with both IBO and Interbase
direct.

That is until we have a more elegent fix!

--
Lester Caine
-----------------------------
L.S.Caine Electronic Services