Problem with dreport crashing

Fairlight fairlite at fairlite.com
Thu Jul 31 10:19:12 PDT 2008


On Thu, Jul 31, 2008 at 11:33:55AM -0400, after drawing runes in goat's blood,
Bruce Easton cast forth these immortal, mystical words:
> I haven't looked deeply at that code above, but two things
> stand out to me at first glance.  You say this is a
> selection processing table called by -v.  But you are

That was a typo.  Both phonetically end in "ee" and I make that mistake
when talking about them and even typing them.  I doublechecked the command
and it -was- set to -v, not -z.  I simply mis-spoke here.

> assigning fields and writing them with the write command
> near the top. And you are using the print command at the
> bottom.  I don't believe either of these are appropriate
> for a selection table.  I have never used a selection table

Well, -something- doesn't like what I'm doing.

However, I can assure you that I regularly write fields in the control
record upon which I sit in every top-level CGI processing table I write.
Helps me keep track of when a slot was last used.  (If I see that the last
time slot 13 of 14 allotted was used only a few months ago, no biggie...if
I run a check regularly and that slot is always less than 3 days old, I
know we're approaching our license slot limit and might have to adjust
something.)

I'll try a few things to try to resolve this.  I'd swear I was told to use
print.  Maybe it was meant to be from output processing, not the selection
table (where I'd personally expect select, although that did nothing).

One question I do have...  

If NO reports match, I'm not going to get any report.  It'll be blank,
basically...as in, nothing will be generated.  I could force a field to
read "NO MATCHES" and carry on with a print on a one-time only basis, but
it'll then have the grand total for records printed as 1, not 0.  How does
one get around this behaviour?  I want to at least get -something- printed,
even if the detail lines are completely empty (I'd prefer "NO MATCHES" by
far), but I need the total to be 0 in any event.  Suggestions?

mark->
-- 
"Moral cowardice will surely be written as the cause on the death
certificate of what used to be Western Civilization." --James P. Hogan


More information about the Filepro-list mailing list