Re: SQR-USERS Digest - 18 Apr 1998 to 19 Apr 1998

[Bruce Mitchell <mitchellb@CYBERUS.CA>]

This error only occurs on this SQR, none of the other SQRs or other parts of
the offending SQR (ie other Selects) cause the problem.  Unfortunately our
server was down all day today so I can't try anything until tomorrow.  The
query in question runs against three views all derived from the same table
with one view derived from another! I'm going to re-create that view and
base it upon the original table rather than another view and see if that helps.

I'll also try it with the -s option and report back.

Thanks for the replies
Bruce

At 12:00 AM 4/20/98 +1800, you wrote:
>
>Date:    Sat, 18 Apr 1998 22:47:24 -0700
>From:    Michael Lee <MLee@APPGROUP.COM>
>Subject: Re: SQLServer Error
>
>Bruce,
>
>Do you get this error when running PeopleSoft delivered SQRs?  If you do
>not get this error when running PeopleSoft delivered SQRs, then it is an
>isolated incident, and you should look at your environment settings and/or
>your SQR code.
>
>If you get the same error when running PeopleSoft delivered SQRs, then
>maybe your installation variables are incorrect.  Do you have all your
>necessary includes?  Are you running this in a single-user environment or
>on the network?
>
>
>Michael K. Lee
>mlee@appgroup.com
>The Application Group, Inc.
>
>