Re: Q: Suppressing NULLs using Forms 4.5

From: Jurij Modic <jurij.modic_at_mf.sigov.mail.si>
Date: 1997/06/03
Message-ID: <33949800.49219898_at_www.sigov.si>#1/1

[Quoted] On 03 Jun 1997 15:40:25 GMT, andrewto_at_kingfish.cse.tek.com (Andrew Tompkins) wrote:

>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.

[Quoted] I can't see how CHR(0) or space can be of more help then NULL in IF or WHILE statements. In fact, it can give you wrong ansver while NULL can't. What exactly are this nastiness?

And wath do you replace nulls in you numeric columns with?

Regards,

---

Jurij Modic                             Republic of Slovenia
tel: +386 61 178 55 14                  Ministry of Finance
fax: +386 61  21 45 84                  Zupanciceva 3

e-mail: jurij.modic_at_mf.sigov.mail.si Ljubljana 1000

---

Received on Tue Jun 03 1997 - 00:00:00 CEST