Is there an easy way using IBO to treat an empty string as NULL when inserting or updating a record ? I know that a field constraint can be used to test for '' but would prefer to not have to modify every table in the database. Currently I am attaching a TDataSource to a TIBOQuery and using the OnUpdateData event to clear all ftString and ftMemo fields containing an empty string. Surely others have run into this same issue and someone has a better solution.

Thanks in advance,

Chris Landowski
Dynamic Software Solutions


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