SELECT aFarmType[IIF(pol.fr_type=0,1,pol.fr_type)] AS farm_type, ...>I've found a workaround, but I'm curious as to what would generate this error.
>DIME aFarmType[5] && policy.fr_type >aFarmType[1] = 'Field Crop Farms ' >aFarmType[2] = 'Truck Farms ' >aFarmType[3] = 'Poultry Farms ' >aFarmType[4] = 'Livestock Farms ' >aFarmType[5] = 'Field Crop and Livestock' > >SELECT pol.fr_type AS farm_type, loc.state,pol.pol_num; > FROM policy pol,location loc; > WHERE loc.agentcode=pol.agentcode and loc.ctrl_num=pol.ctrl_num; > AND loc.locat_num = 1; > ORDER BY farm_type,state; > INTO CURSOR tmp>
>SELECT DISTINCT farm_type FROM tmp>I will get values 1,2,3,4,5.
SELECT aFarmType[farm_type] FROM tmp>works just fine. However, when I try to combine all this into one SELECT statement
>SELECT aFarmType[pol.fr_type] AS farm_type, loc.state,pol.pol_num; > FROM policy pol,location loc; > WHERE loc.agentcode=pol.agentcode and loc.ctrl_num=pol.ctrl_num; > AND loc.locat_num = 1; > INTO CURSOR tmp >>I get an "Invalid Subscript Reference" error.