a:1:{i:0;a:7:{s:7:"cod_prj";s:7:"Veratex";s:6:"versao";s:1:"1";s:7:"cod_apl";s:16:"dye_standdf_form";s:4:"nome";s:15:"FinNo2_onChange";s:4:"tipo";s:1:"A";s:5:"parms";s:0:"";s:6:"codigo";s:381:"/**
 * Selecting a field from another table
 */

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

if (isset({rs[0][0]}))     // Row found
{
    {fin_no} = {rs[0][0]};
    {finish} = {rs[0][1]};
}
		else     // No row found
{
		    {finish} = '';
    {fin_no} = '';
}";}}