Hiding empty DATE fields in 4D?

Article View: comp.sys.mac.databases

Article #204

Back to comp.sys.mac.databases Previous Next

#204

From: Paul E. Jacoby
Date: Tue, 18 Aug 1992 14:03

27 lines
1491 bytes

(I'll post this here too for wider distribution)

Does anyone have a good way to 'hide' empty DATE fields when printing a
layout?  I have a number of date fields in a layout, any number of which
may not yet have data entered in them.  4D is happy to provide
"00/00/00" as a default value, but I don't want this value to show in
the printout!

I have played with SET COLOR( ) with no success at this point. This code
_doesn't_ work:

  If (Before & isprinting)
     If ([traveler]datein=!00/00/00!) ` date is blank
        SET COLOR(datein;0)  ` hide blank date fields
     End if 
  End if

Aside from not working, this approach is _slow_ as the Before phase
executes for EVERY record being printed.  Yuck.

* If I have to, I'll make the fields ALPHA instead of date, but I'd
  prefer to NOT make this change.
-- 
| Paul E. Jacoby, Consultant  | pejacoby@mmm.com      CIS:70404,2507 |
| David Mitchell & Associates |                                      |
| 3M Center, Bldg 235-3F-27   |--------------------------------------|
| Maplewood, MN   55144-1000  | (612) 737-3211 [w]      731-6392 [h] |

Technical Details

Message-ID: <1992Aug18.140327.3507@mmm.serc.3m.com>

Path:

arc1-ca.pugleaf.net!sparky!uunet!wupost!darwin.sura.net!mips!sdd.hp.com!news.cs.indiana.edu!umn.edu!mmm.serc.3m.com!pejacoby

Show Full Headers

Complete Article Headers

Newsgroups: comp.sys.mac.databases
Path: arc1-ca.pugleaf.net!sparky!uunet!wupost!darwin.sura.net!mips!sdd.hp.com!news.cs.indiana.edu!umn.edu!mmm.serc.3m.com!pejacoby
From: pejacoby@mmm.serc.3m.com (Paul E. Jacoby)
Subject: Hiding empty DATE fields in 4D?
Message-ID: <1992Aug18.140327.3507@mmm.serc.3m.com>
Organization: 3M Company
Date: Tue, 18 Aug 92 14:03:27 GMT
Lines: 27