[sqr-users] Dynamic Array Size - Version 6.2

["Jessie Dickenson" <jmdickenson@rainbow-media.com>]

I need help with dynamic array sizing. 

Here is my situation:
I need to create an array & assign the size to a number based on the total 
count of agents in a given geographic area.

So, I do the following:
1. I determine the number of agents & assign that count to a variable, #Count.
2, Then, I use this variable in the #Define command to assign this value to a 
substitution variable AgentCount.
3. Then, I use this substitution variable, AgentCount for the size parameter 
within a Create-Array command.

I get the following SQR error: (SQR 3526) Missing or incorrect SIZE= in 
CREATE-ARRAY.

While debugging this, I find the correct value assigned to the substitution 
variable, AgentCount. However the Create-Array fails. 

I cannot get the agent count within the setup portion, since the count is 
returned by a PL/SQL procedure.

Can somebody let me know if I am doing something incorrectly. 

Thanks in advance.
Jessie

BEGIN-PROCEDURE Get_Agent_Count
BEGIN-SELECT ON-ERROR=SQR_ERROR((1,'Get_Agent_Count')
COUNT (DISTINCT MY_TBL.AgentLENGTH)     &Count

        Let #Agent_Count = &Count
FROM 
        MY_SCHEMA.MY_TBL
WHERE 
        MY_TBL.RPT_RUN_HDR_ID           = #rpt_run_hdr_id
END-SELECT

#Define AgentCount #Agent_Count
        
Create-Array Name=Arr_Totals size={AgentCount}  
END-PROCEDURE Get_Agent_Count


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