[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

FW: Return Status and Win 95



        mreel @ CONCENTRIC.NET (Michael Reel)
01/10/97 16:17
To: SQR-USERS @ list.iex.net (Multiple recipients of list SQR-USERS) @ SMTP
cc:
Subject: Return Status and Win 95



I have a friend who is trying to do some dos scripting in Windows 95.
He is
having a problem with the return status of an SQR called in his Dos
script.

The Script looks sortof like this (I am not a very fluent in DOS
scripting)
-------
sqr filename username/password@database
if errorlevel 0 goto ok
echo An Error has occurred
ok:
echo End of Script
----------

The SQR look like this
--------
begin-report
   move 9 to #return-status
   display 'Return Status = ' noline
   display #return-status
end-report
----------

Here is the problem.  In the SQR, the #return-status is displayed as 9.
When the SQR ends
the DOS script sees the errorlevel as 0 and jumps to OK.  Has anybody
seen anything like
this?  Unfortunately, I not sure what version of SQR it is but I pretty
sure it is version 3 for
SQL Windows.

Thanks for any help.

Mike Reel
DataStudy, Inc.