Re: Error -4518: Cannot allocate any more space
Posted in 1992
Topics: Connectivity: ESQL/C, 4GL & Embedded SQL
In article <9726@emory.mathcs.emory.edu> dave.snyder@snide.com (Dave Snyder) writes: > Quoting Marien de Clercq... > } > } Can someone please help me with error -4518: > } > } "The 4GL program cannot allocate any more space for temporary > } string storage." > } > } I sometimes get this error in reports. > } > This error can be caused by any of the following: > 1) CASE statements without an OTHERWISE > 2) CASE statements that look like this: > CASE dummy_var > WHEN 0 > ..... > WHEN 1 > ..... > WHEN 2 > ..... > END CASE > instead of this: > CASE > WHEN dummy_var = 0 > ..... > WHEN dummy_var = 1 > ..... > WHEN dummy_var = 2 > ..... > END CASE > 3) Reports with excessive string usage (ie. USING) One thing you can do to reduce the contents of string storage is to assign redundant strings associated with USING to variables and then refer to the variable -- let str1 = '$$$$$$$$.$$' print ... using str1 > > I probably missed a few. Call tech. support, they faxed me something that > showed examples of what caused the error and how to work around it. I > found that by compiling it to an executable, the problem always goes away. > > DAS > -- > David Snyder @ Snide Computer Services - Folcroft, PA Current Release > is db4glgen-3.7 > UUCP: ..!uunet!das13!dave INTERNET: dave.snyder@snide.com -- -- _____ __ / __ _ _ / ) __ __ __ / /__) / ` / ` | / /__/ / ) / ) /__) {_/ (__, / / |/ / (__/ /--' (__,