date field empty

Article View: borland.public.vdbase.data.sql

Article #1168

Back to borland.public.vdbase.data.sql Previous Next

#1168

From: Andrea Starz
Date: Thu, 23 Apr 1998 00:00

16 lines
1018 bytes

I have Vdb 7.01
My problem: in a form or report testing a date field if it's empty !
Online help recommended to use the ISBLANK() function instead of
EMPTY(), but it's not a good idea in this case.
The function ISBLANK(form.query.rowset.fields["FIELDNAME"].value)
and EMPTY(form.query.rowset.fields["FIELDNAME"].value) returning a false
value.
Only solution is comparison with null value
(form.query.rowset.fields["FIELDNAME"].value==null)
correctly return true.

It's a bug or it's correct and i wrong any ?

Thanks a lot
Andrea

Technical Details

Message-ID: <353F07B0.6319@mail.tin.it>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff5a1,3c7c673e184ccf06,start
X-Google-Attributes: gidff5a1,public
From: Andrea Starz <starzand@mail.tin.it>
Subject: date field empty
Date: 1998/04/23
Message-ID: <353F07B0.6319@mail.tin.it>
X-Deja-AN: 346923813
Content-Transfer-Encoding: 7bit
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Organization: Another Netscape Collabra Server User
Newsgroups: borland.public.vdbase.data.sql