Re: Error -4518: Cannot allocate any more space

In article <1992Oct8.161759.12356@nijmeg.ingr.com> clercqm@nijmeg.ingr.com (Marien de Clercq) writes: >Can someone please help me with error -4518: > > "The 4GL program cannot allocate any more space for temporary > string storage." > [ stuff deleted ] > >Who can give me a clue about where to look for a solution ??? > > > >-- >Marien de Clercq ___ "She was bored with the man, >Intergraph European Mfg. bv. /|/| // because no matter what happened >Nijmegen - The Netherlands / | __// he was always happy as a ... >E-mail: clercqm@nijmeg.ingr.com / |/_/ \\___ clown" - Laurie Anderson I ran into this same problem recently. What was the apparent cause in my case was that all the temporary string space was being eaten up by a function called from within a loop which returns a string variable. My solution was to make the variable a global, which solved the problem. Other possible causes for error -4518: 1- use of GROUP BY 2- literal strings 3- CASE statement with no OTHERWISE clause 4- use of USING 5- use of SPACE 6- use of upshift and downshift I hope this helps, -- dave =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= David Jennings Informix Software, Inc. Programmer/Analyst, MIS (Contractor) uunet!pyramid!infmx!davidj