Re: Error: SQR 4900

[Randy Kirkpatrick <randyk@MESSAGEMEDIA.COM>]

Thanks everyone for your help. I'm not using Peoplesoft. I'm using Brio
Portal. I addes the entry in the sqr.ini file on my test machine and the
production sqr server and everything is fine now.

Randy Kirkpatrick

-----Original Message-----
From: Discussion of SQR, Brio Technology's database reporting language
[mailto:SQR-USERS@list.iex.net]On Behalf Of Blakesley, Melinda J.
Sent: Tuesday, August 22, 2000 11:10 AM
To: SQR-USERS@list.iex.net
Subject: Re: Error: SQR 4900


yes, I got the same error yesterday.  Create a text file (such as mfile.dat)
with a line

DYNAMICARGS = 100

When you run your sqr you add the -M options.

sqr mysqr.sqr -Mmfile.dat

The default value of dynamicargs is 70.

Melinda

-----Original Message-----
From: Randy Kirkpatrick [mailto:randyk@MESSAGEMEDIA.COM]
Sent: Tuesday, August 22, 2000 11:13 AM
To: SQR-USERS@LIST.IEX.NET
Subject: Error: SQR 4900


Hey guys,

I never received this error before today after adding some code to a report.
Any insights?

(SQR 4900) Out of dynamic SQL arguments [$...]; use -Mfile to increase
DYNAMICARGS.


Randy Kirkpatrick
Oracle DBA
MessageMedia, Inc.
303 381-7727