>> Thanks for the advice.
That's what I have done in the past. I just wanted to make sure that there
is a simpler way. I like to keep my database lean. <<
I would do it in code. Something like the following:
select count(rowid) into countvariable from tablename where whereclause
if countvariable > 0 then
print properReport
else
output print
type file.txt
output print
endif
print.txt could be a file explaining the situation, or could be replaced by
a line with the date and a message.
================================================
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [EMAIL PROTECTED]
In the message body, put just two words: INTRO rbase-l
================================================
TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED]
In the message body, put just two words: UNSUBSCRIBE rbase-l
================================================
TO SEARCH ARCHIVES:
http://www.mail-archive.com/rbase-l%40sonetmail.com/