I would recommend keeping the check system for not printing the NULL.
The NULL setting is database wide, and can cause hassles elsewhere i you
set it to a space. You could use a different syntax for your printing
check rather than the IF/ELSE/ENDIF you are using. I'm not at all sure
how much processing time this would save, but it might save a few
nanoseconds per row. I'm assuming that vicdala is text at this point.
SET VAR vicdala = (IFNULL(.vicdala,' ',.vicdala))
Albert
On 10/24/2013 8:49 AM, marc schluter wrote:
I wrote a Pagemode report 10 years ago but I need to add some new
fields to it. I think I wrote the code at the bottom so I wouldn't
get -0- for null values in the report but I was wondering if it would
be better to change the code to
Set Null ''
WRITE .vicda1a=8 AT &vline,16
instead of this
IF vicda1a IS NULL THEN
WRITE ' ' AT &vline,16
ELSE
WRITE .vicda1a=8 AT &vline,16
ENDIF
Thanks for any suggestions
Marc
