[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
Re: [sqr-users] SQR 1302 - SQL buffer too small;use -Mfile to increase SQLSIZE.
- Subject: Re: [sqr-users] SQR 1302 - SQL buffer too small;use -Mfile to increase SQLSIZE.
- From: Gustavo Comanduci Zocrato <gczocrato@yahoo.com.br>
- Date: Mon, 19 Sep 2005 16:47:13 -0300 (ART)
- Delivery-date: Mon, 19 Sep 2005 14:48:16 -0500
- Domainkey-signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com.br;h=Message-ID:Received:Date:From:Subject:To:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding;b=GDFXeZuz5l4OYwDMHUUvufSvzvfYXxptM2IQJPJLk8sIjAbFaLD8cwhqstTCd8ozdqRBdCtua/sruveSHLpIGrJvULDHYBm6abwv42msCG1A6e8btzLb8yA564C7832Tvbad9MgRNH3rCXDNVprDnDmXGjOgvSqP/nOAIHrnyDg=;
- In-reply-to: <F46D2E2C02C29E42BE6E1D1EBA9070A60D1B63@ITS-EXMBX4.its.corp.gwl.com>
- List-id: "This list is for discussion about the SQR database reportinglanguage from Hyperion Solutions." <sqr-users.sqrug.org>
Hello Carla,
Change the Processing-Limits section in SQR.INI file
(Generally in c:\windows folder).
FROM :
[Processing-Limits]
;SQLSIZE=4000
TO:
[Processing-Limits]
SQLSIZE=6000
6000 is a try, maybe it must be bigger or smaller.
Gustavo Comanduci
--- "Thompson, Carla" <carla.thompson@gwl.com>
escreveu:
> I'm getting the following error message:
>
> (SQR 1302) SQL buffer too small; use -Mfile to
> increase SQLSIZE.
>
> I added a "UNION" to a Select statement, and I
> didn't think that it would effect the SQL buffer
> since the same columns will be selected in the
> second part of the UNION.
>
> Suggestions welcomed.
>
> Thank!
>
> Carla Lynn!
>
> _______________________________________________
> sqr-users mailing list
> sqr-users@sqrug.org
> http://www.sqrug.org/mailman/listinfo/sqr-users
>
__________________________________________________
Faça ligações para outros computadores com o novo Yahoo! Messenger
http://br.beta.messenger.yahoo.com/
_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users