SET ERROR MESSAGES ON
This should be left on permanently.
I like to test the file before the print
OUTPUT .vFileSpec
Set var vHoldError = .MyErrorVariable
OUTPUT SCREEN
if vHoldError <> 0 then -- file cannot be opened
--whatever
endif
Dennis McGrath
Software Developer
QMI Security Solutions
1661 Glenlake Ave
Itasca IL 60143
630-980-8461
[email protected]
From: [email protected] [mailto:[email protected]] On Behalf Of Stephen Markson
Sent: Monday, January 28, 2013 10:28 AM
To: RBASE-L Mailing List
Subject: [RBASE-L] - Is a file Open?
Good day,
How does one check if a file is open (in use)?
If you do R> OUTPUT somefile,
or R> PRINT reportname OPTION PDF|FILENAME somefile,
and someone has the file open, then nothing is produced.
As far as I can tell, the error variable is not set and SQLCODE is not affected.
Regards,
Stephen Markson
The Pharmacy Examining Board of Canada
416.979.2431 x251
