subscript must be between 1 and the size of the array

[ncchish]

I'm getting this error with a formula in CR 8.5. Can anyone tell me what is wrong with this formula?

Thanks!

BooleanVar SelectRec := false;
NumberVar Counter;
Global NumberVar Array MgrSSN;
for Counter := 1 to UBound({?MgrSSN}) do
if ({AGMRV_HIERARCHY.AGT_MGR_TAX_ID_NBR} = (MgrSSN[Counter]) and {AGMRV_HIERARCHY.AGY_AGCY_NBR} = {?Agency}) then SelectRec := true;
Counter := Counter + 1;
SelectRec;

 

[mbarron]

You haven't assigned an array to your MgrSSN variable that you are referencing in your loop.

Either assign the variable
Global NumberVar Array MgrSSN:={?MgrSSN};

or change this line:
if ({AGMRV_HIERARCHY.AGT_MGR_TAX_ID_NBR} = (MgrSSN[Counter]) and

to:
if ({AGMRV_HIERARCHY.AGT_MGR_TAX_ID_NBR} = (?MgrSSN[Counter]) and

Mike

 

[mbarron]

Ooops
the last part of my post should have been

or change this line:
if ({AGMRV_HIERARCHY.AGT_MGR_TAX_ID_NBR} = (MgrSSN[Counter]) and

to:
if ({AGMRV_HIERARCHY.AGT_MGR_TAX_ID_NBR} = ({?MgrSSN}[Counter]) and
Mike



Mike