a:5:{i:0;a:7:{s:7:"cod_prj";s:7:"Veratex";s:6:"versao";s:1:"1";s:7:"cod_apl";s:30:"data_finish_stylefiltered_form";s:4:"nome";s:13:"DYER_onChange";s:4:"tipo";s:1:"A";s:5:"parms";s:0:"";s:6:"codigo";s:13:"dyerupdate();";}i:1;a:7:{s:7:"cod_prj";s:7:"Veratex";s:6:"versao";s:1:"1";s:7:"cod_apl";s:30:"data_finish_stylefiltered_form";s:4:"nome";s:21:"FinishSelect_onChange";s:4:"tipo";s:1:"A";s:5:"parms";s:0:"";s:6:"codigo";s:15:"changefinish();";}i:2;a:7:{s:7:"cod_prj";s:7:"Veratex";s:6:"versao";s:1:"1";s:7:"cod_apl";s:30:"data_finish_stylefiltered_form";s:4:"nome";s:12:"changefinish";s:4:"tipo";s:1:"M";s:5:"parms";s:0:"";s:6:"codigo";s:353:"/**
 * Selecting a field from another table
 */

// Check for record
$check_sql = "SELECT fin_long_name,fin_short_name"
   . " FROM finish"
   . " WHERE fin_short_name = '" . {finishselect} . "'";
sc_lookup(rs, $check_sql);

if (isset({rs[0][0]}))     // Row found
{
    {fin_long_name} = {rs[0][0]};
	{fin_short_name}={rs[0][1]};
   
}
";}i:3;a:7:{s:7:"cod_prj";s:7:"Veratex";s:6:"versao";s:1:"1";s:7:"cod_apl";s:30:"data_finish_stylefiltered_form";s:4:"nome";s:10:"dyerupdate";s:4:"tipo";s:1:"M";s:5:"parms";s:0:"";s:6:"codigo";s:828:"$getadd="select prefix,name,address1,address2,city,state,zip_code from veratex2.supref
where code='{dyer}'";
sc_lookup(rs,$getadd);	
if (isset({rs[0][0]}))
	{
	$prefix={rs[0][0]};	
		}
else
	{
     $prefix='';
		}
if (isset({rs[0][1]}))
	{
	$name={rs[0][1]};
		
		echo $name;
		}
else
	{
     $name='';
		}
{name}=$prefix.' '.$name;
	
if (isset({rs[0][2]}))
	{
	{address1}={rs[0][2]};	
		}
else
	{
     {address1}='';
		}
if (isset({rs[0][3]}))
	{
	{address2}={rs[0][3]};	
		}
else
	{
     {address2}='';
		}
if (isset({rs[0][4]}))
{
$city={rs[0][4]};
}
else
	{
		$city='';
	}
if (isset({rs[0][5]}))
{
	$state={rs[0][5]};
}
else
	{
		$state='';
		}
if (isset({rs[0][6]}))
	{
		$zip={rs[0][6]};
}
else
	{
		$zip='';
			}
	{address3}=$city." ".$state."  ".$zip;


";}i:4;a:7:{s:7:"cod_prj";s:7:"Veratex";s:6:"versao";s:1:"1";s:7:"cod_apl";s:30:"data_finish_stylefiltered_form";s:4:"nome";s:14:"onBeforeUpdate";s:4:"tipo";s:1:"E";s:5:"parms";s:0:"";s:6:"codigo";s:0:"";}}