RE: [sqr-users] dynamic array size

["Knapp, Richard" <KnappR@umsystem.edu>]

For version 4.3 which I use, arrays are created before any code is
executed so a dynamic sizing is not possible (in this version.)

Richard Knapp
Database Programmer/Analyst
Institutional Research and Planning
University of Missouri System
573-882-8856
knappr@umsystem.edu

-----Original Message-----
From: sqr-users-bounces+knappr=umsystem.edu@sqrug.org
[mailto:sqr-users-bounces+knappr=umsystem.edu@sqrug.org] On Behalf Of
Sony Dada
Sent: Wednesday, February 23, 2005 10:29 AM
To: sqr-users@sqrug.org
Subject: [sqr-users] dynamic array size

Hi,

I need some advice from sqr experts. Thought it would be simple but
having 
hardtime to resolve it.

Issue:

create-array name=BUs size=100
     field=legal_entity:char

I have to set above 100 as dynamic and I know the count before I create
this 
array. So, I changed the above code as below:-

select count(*) &cnt
let #count = &cnt
from abc_table
  show 'count : ' #count

create-array name=BUs size=#count
     field=legal_entity:char

After I changed the program, it is not recognizing the #count. I
replaced 
with {#count} but not working. I looked at the old postings and looks
like 
it can be resolved. Could you send some suggestions on this.

Thanks in advance.
Sony



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

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