RE: [sqr-users] dynamic array size

[Don Mellen <donm@ontko.com>]

Things have changed in recent versions!  

EXTENT was added to the create-array command in version 8 of
non-peoplesoft sqr. Still needs a literal, but it can grow past that.

On Wed, 23 Feb 2005, the dragon wrote:

> All,
> 
> Unless things have changed in recent versions, arrays are created at compile 
> time.  Therefore any dynamic declaration of the array must happen at compile 
> time and can not be dependent upon any sql information.  There might be 
> various ways to get around this, such as running an sql select in a script 
> first and then passing that variable into the sqr.
> 
> Ultimately, I guess it boils town to cost-benefit.....  Is it really worth 
> the effort to make something dynamic just so you can prove tricky stuff 
> works? or is it easier/more resource efficient to determine the maximum size 
> it could ever be and add 10 - 20 percent?  Given the speed of hardware and 
> the cost of RAM, I am guessing the second is more cost effective.
> 
> 
> hope this helps.
> 
> peace,
> clark 'the dragon' willis

-----------------------------------------------------------------------
Donald Mellen  | Ray Ontko & Co. - Richmond, IN - http://www.ontko.com/
donm@ontko.com |  "In the beginning, there was nothing, which exploded"


_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users