[[https://www.revelation.com/|Sign up on the Revelation Software website to have access to the most current content, and to be able to ask questions and get answers from the Revelation community]]


==== MSG Line 1 B114 Maximum number of variables exceeded (AREV Specific) ====
=== At 21 MAY 1998 01:34:18AM Giles Wycherley wrote: ===
 
{{tag>"AREV Specific"}}
 
<QUOTE>
I have seen previous topics regarding this message, but these where a while ago and so I am submitting this.

Basically, I am trying to generate a report.  To do this a selection is made at the beginning of the program and subsequently the figures

are collated from this.

The message is appearing a long period of time after processing has begun.  The program is run on a large table.  The AREV version is 3.12.

It seems as though the size of this table is a factor, is this the case?

Are there any ways of dealing with this message or likely causes?

Any thoughts would be appreciated.
</QUOTE>
----

=== At 25 MAY 1998 04:40PM abjones wrote:  ===

<QUOTE>Maximum number of variables exceeded!  AREV has a limited number of

"variables" in a pool shared by system functions, common blocks, and

user programs.  The easiest way to use the 5000 or so available

variables is to use arrays since each cell in an array is allocated

one variable.  Your program logic must conserve this pool by using

other resources such as dynamic arrays ( limited to <64K bytes total

and slow ) or temporary AREV files ( very slow, but high capacity).

Subroutines and functions will return variables to the pool upon

completion. Perhaps a combination array where each element is a dynamic array can be used to balance speed of computation while

conserving "variables".  Good Luck!

</QUOTE>


[[https://www.revelation.com/revweb/oecgi4p.php/O4W_HANDOFF?DESTN=O4W_RUN_FORM&INQID=NONWORKS_READ&SUMMARY=1&KEY=61E92A96BD4532C58525660B001E9B5D|View this thread on the  forum...]]