a:12:{i:0;a:7:{s:7:"cod_prj";s:7:"Veratex";s:6:"versao";s:1:"1";s:7:"cod_apl";s:17:"dye_dyeorder_form";s:4:"nome";s:14:"Dyer2_onChange";s:4:"tipo";s:1:"A";s:5:"parms";s:0:"";s:6:"codigo";s:15:"{dyer}={dyer2};";}i:1;a:7:{s:7:"cod_prj";s:7:"Veratex";s:6:"versao";s:1:"1";s:7:"cod_apl";s:17:"dye_dyeorder_form";s:4:"nome";s:14:"FinNo_onChange";s:4:"tipo";s:1:"A";s:5:"parms";s:0:"";s:6:"codigo";s:386:"/**
 * Selecting a field from another table
 */

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

if (isset({rs[0][0]}))     // Row found
{
    {finish_no} = {rs[0][0]};
    {finish} = {rs[0][1]};
}
		else     // No row found
{
		    {finish} = '';
    {finish_no} = '';
}";}i:2;a:7:{s:7:"cod_prj";s:7:"Veratex";s:6:"versao";s:1:"1";s:7:"cod_apl";s:17:"dye_dyeorder_form";s:4:"nome";s:17:"Knitter2_onChange";s:4:"tipo";s:1:"A";s:5:"parms";s:0:"";s:6:"codigo";s:21:"{knitter}={knitter2};";}i:3;a:7:{s:7:"cod_prj";s:7:"Veratex";s:6:"versao";s:1:"1";s:7:"cod_apl";s:17:"dye_dyeorder_form";s:4:"nome";s:14:"StdDF_onChange";s:4:"tipo";s:1:"A";s:5:"parms";s:0:"";s:6:"codigo";s:742:"/**
 * Selecting a field from another table
 */

// Check for record
$check_sql = "SELECT frame,fwidth,panels,cpi,wpi,gryield,fyield,finish,fin_no,put_up,spec1,spec2,spec3"
   . " FROM standdf"
   . " WHERE number = '" . {stddf} . "'";
sc_lookup(rs, $check_sql);

if (isset({rs[0][0]}))     // Row found
{
    {frame} = {rs[0][0]};
    {fwidth} = {rs[0][1]};
	{panels} = {rs[0][2]};
    {cpi} = {rs[0][3]};	
	{wpi} = {rs[0][4]};
    {req_gr_yld} = {rs[0][5]};
	{req_fin_wt} = {rs[0][6]};
    {finish} = {rs[0][7]};
	{finish_no} = {rs[0][8]};
    {put_up} = {rs[0][9]};
	{spec1} = {rs[0][10]};
    {spec2} = {rs[0][11]};	
	{spec3} = {rs[0][12]};
}
		else     // No row found
{
		    {frame} = 'STD DF NOT FOUND';
}";}i:4;a:7:{s:7:"cod_prj";s:7:"Veratex";s:6:"versao";s:1:"1";s:7:"cod_apl";s:17:"dye_dyeorder_form";s:4:"nome";s:8:"changegs";s:4:"tipo";s:1:"M";s:5:"parms";s:0:"";s:6:"codigo";s:160:"[var_grstyle]={gs2};
sc_lookup(dataset1, "SELECT width FROM grstyle WHERE NEW_style = '[var_grstyle]'");
{greige_wi} ={dataset1[0][0]};
{gs}=[var_grstyle];
";}i:5;a:7:{s:7:"cod_prj";s:7:"Veratex";s:6:"versao";s:1:"1";s:7:"cod_apl";s:17:"dye_dyeorder_form";s:4:"nome";s:12:"gs2_onChange";s:4:"tipo";s:1:"A";s:5:"parms";s:0:"";s:6:"codigo";s:11:"changegs();";}i:6;a:7:{s:7:"cod_prj";s:7:"Veratex";s:6:"versao";s:1:"1";s:7:"cod_apl";s:17:"dye_dyeorder_form";s:4:"nome";s:13:"onAfterInsert";s:4:"tipo";s:1:"E";s:5:"parms";s:0:"";s:6:"codigo";s:0:"";}i:7;a:7:{s:7:"cod_prj";s:7:"Veratex";s:6:"versao";s:1:"1";s:7:"cod_apl";s:17:"dye_dyeorder_form";s:4:"nome";s:17:"onApplicationInit";s:4:"tipo";s:1:"E";s:5:"parms";s:0:"";s:6:"codigo";s:0:"";}i:8;a:7:{s:7:"cod_prj";s:7:"Veratex";s:6:"versao";s:1:"1";s:7:"cod_apl";s:17:"dye_dyeorder_form";s:4:"nome";s:14:"onBeforeInsert";s:4:"tipo";s:1:"E";s:5:"parms";s:0:"";s:6:"codigo";s:0:"";}i:9;a:7:{s:7:"cod_prj";s:7:"Veratex";s:6:"versao";s:1:"1";s:7:"cod_apl";s:17:"dye_dyeorder_form";s:4:"nome";s:6:"onInit";s:4:"tipo";s:1:"E";s:5:"parms";s:0:"";s:6:"codigo";s:0:"";}i:10;a:7:{s:7:"cod_prj";s:7:"Veratex";s:6:"versao";s:1:"1";s:7:"cod_apl";s:17:"dye_dyeorder_form";s:4:"nome";s:9:"onLoadAll";s:4:"tipo";s:1:"E";s:5:"parms";s:0:"";s:6:"codigo";s:22:"[var_status]={status};";}i:11;a:7:{s:7:"cod_prj";s:7:"Veratex";s:6:"versao";s:1:"1";s:7:"cod_apl";s:17:"dye_dyeorder_form";s:4:"nome";s:10:"onNavigate";s:4:"tipo";s:1:"E";s:5:"parms";s:0:"";s:6:"codigo";s:0:"";}}