On 14 Jan 2002 at 15:32, TeamIBO wrote:

> Run the IB_Monitor to see what is actually being posted. It may be
> that you are posting blank string values (which is not the same as
> null). You may need to apply the BLANKISNULL column attribute, or
> write triggers on the table to also check for blanks.
>
> --
> Geoff Worboys - TeamIBO
> Telesis Computing

Thanks Geoff,
Applying the BLANKISNULL fixed the problem :)
Regards,
Hian