At 10:21 AM 1/19/2009, Lawrence Lustig wrote:
Also, I've noticed a second, potentially related problem. Previously when
I tried to print a report that really contained no data, I'd get the famous
error 2059 No Rows Found. I could check the error status (or SQLCode 100)
and tell the user there was nothing there to print. Now, however, if I try
to print a report with no records found I _do_ see a report the same empty
report that occurs when my "problem" appears. I can recode to check for
data _before_ printing the report, but that requires 1) code changes and 2)
a potentially time consuming count (for highly processed views that take
some time to return even COUNT = 1).
Any suggestions?
Interestingly ...
Reviewing all responses and suggestions, I didn't see a single reference
to what update or build of R:BASE 7.6 or Turbo V-8 is being used in your
second, potentially related problem.
So, I just tried the following:
01. Started two separate sessions of R:BASE 7.6 (7.6.6.30214) and Turbo
V-8 for Windows (8.0.20.30214).
02. CONNected RRBYW14 with 7.6 and RBYW15 with Turbo V-8
03. At the R> Prompt:
PRINT Invoice WHERE TransID = 1001
The beautiful invoice printed accordingly with no errors, as there was
a valid transaction with TransID = 1001.
Then, a different (non-existent) TransID = 9999 was used to replicate
your scenario.
PRINT Invoice WHERE TransID = 9999
An -ERROR- "No rows exist or satisfy the specified clause (2059)" was
generated which is the correct -ERROR- message as there was no record
with TransID = 9999 and I didn't see a blank report on screen either.
Keeping that perspective in mind, and keeping everything up-to-date,
you don't need to either re-code to check for data _before_ printing
the report, to change any code, nor use a potentially time consuming
count (for highly processed views that take some time to return even
COUNT = 1).
Very Best R:egards,
Razzak.
--- RBASE-L
=======================3D=======================3
D=
TO POST A MESSAGE TO ALL MEMBERS:
Send a plain text email to [email protected]
(Don't use any of these words as your Subject:
INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH,
REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP)
=======================3D=======================3
D=
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: INTRO
=======================3D=======================3
D=
TO UNSUBSCRIBE:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: UNSUBSCRIBE
=======================3D=======================3
D=
TO SEARCH ARCHIVES:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: SEARCH-n
(where n is the number of days). In the message body,
place any
text to search for.
=======================3D=======================3
D=
