Re: Q: Suppressing NULLs using Forms 4.5

[Quoted] In article <5n15uh$skl$2_at_orion-fddi.rz.uni-ulm.de>   wzimmer_at_atair.rz.uni-ulm.de (Walter Zimmer) writes:

>
> Sorry for not having an answer to your problem, but I always wanted to
> know where someone would use a space as a valid value.
>
> Can you enlighten me ?
>
> Thanks,
> Walter
>

We used to use a space as an indicator of an open column in a row in place NULL because of the nastiness that NULL does when retrieved from the database and used in conditions for 'if' or 'while' statements. We now use 'chr(0)' for this purpose. We now don't have to check for NULL after every retrieval.

--Andy
-- 
-------------------------------------------------------
| Andrew G. Tompkins    | #include <disclaimer.std.h> |
| Software Design Eng.  ------------------------------|
| Tektronix, Inc.                                     |
| Phone: (503) 627-5172      fax: (503) 627-5548      |
| email: Andrew.Tompkins_at_tek.com (work)               |
|        andytom_at_teleport.com (home)                  |
| http://www.teleport.com/~andytom/                   |
-------------------------------------------------------