[sqr-users] dynamic array size

["Sony Dada" <sony_dada@hotmail.com>]

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