Stephen,
Looks like
SELECT arrest
SCATTER TO NAME oRec
do savemastwped.prg with oRec, < some other parameters that sren't in arest table>
would be a better solution.
> do savemastwped.prg with arrest.arr_addr1,"",arrest.arr_city,arrest.arr_name1,;
> arrest.arr_name2,arrest.arr_name3,arrest.arr_dob,arrest.arr_phone,;
> arrest.arr_ssno,arrest.arr_state,arrest.arr_zip,arrest.arr_ardt,;
> arrest.arr_photno,arrest.arr_artime,arrest.arr_ardt,arrest.arr_sex,;
> arrest.arr_race,arrest.arr_height,arrest.arr_weight,arrest.arr_hair,;
> arrest.arr_eyes,arrest.arr_build,arrest.arr_glass,arrest.arr_hisp,;
> arrest.arr_tattoo,arrest.arr_complx,arrest.arr_relig,arrest.arr_beard,;
> arrest.arr_must,arrest.arr_leftrg,"ARREST",arrest.arr_keyid,arrest.arr_aptno,;
> arrest.arr_stid,arrest.arr_fbino,arrest.arr_cntyid
>
>&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&
>first line of code in savemastwped.prg
>&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&
>parameters l_addr1,l_addr2,l_city,l_lname,l_fname,l_mname,l_dob,l_phone,;
> l_ssnum,l_state,l_zip,l_photdt,l_photid,l_phottm,l_date,l_sex,l_race,l_height,;
> l_weight,l_hair,l_eyes,l_build,l_glass,l_hisp,l_tattoo,l_complx,l_relig,l_beard,;
> l_must,l_leftrg,l_module,l_keyid,l_aptno,l_stid,l_fbino,l_cntyid
--sb--