Wirt after Costas,

> > How can I get an Image/SQL db to allow  "null" items (inserted
> as null or
> >  updated to null) ?
>
> The answer is: attend the next SIGIMAGE meeting and put your
> entire $100 on
> item number 37 (or whatever the "null" item happens to be on that IMAGE
> improvement ballot).

Unfortunately, as Wirt pointed out -- Image/SQL will fill a field with
spaces or zeros, if that field does not have a value - as opposed to using
NULL, which is the default (unless that field is defined as not allowing
NULL values).

So, if one uses UPDATE or INSERT, and places no value in a field of Type
"X", one gets spaces.  Likewise, if no value is placed in a field of type
"Z" or other numeric, one gets a SIGNED ZERO.

Best Regards,
Joe

==========================================================
Joe Geiser, Senior Partner, CSI Business Solutions, LLC
 ** Your Client-Server and Internetworking Specialists **
Phone: +1 (215) 945.8100  Fax: +1 (215) 943.8408
*New* Toll-Free (US/Canada): (877) 945-8100
http://www.csillc.com      mailto:[log in to unmask]
==========================================================
HP Channel Partner         Allaire Alliance Partner
Microsoft ClubWin - Team One