O$: Null Fields

Joe Maus jmaus at theccgllc.com
Tue Apr 21 12:56:00 EDT 2009

> We don't store any NULL's in our database, except for dates in db's  
> that don't allow blank dates, so before any insert, update we do a  
> simple sendall to set every NULL field to '' or 0 depending on its  
> type.  Works for us, maybe not for everyone.

Won't work on Oracle.  Just try storing '' using Oracle - it will convert it to null.  Several other backends do the same thing, that is, empty = null when the database actually goes to store the empty field.


Joe Maus

More information about the omnisdev-en mailing list