Examples: Explorer_Set_SQL_Query_Field


The following example is the Explorer_Get_SQL_Query_Fields procedure from the sample integrating application. It specifies which fields from the IG_Leads_MSTR table used for the Leads SmartList object are required to uniquely identify each row in the table.

in integer IN_Object_Dict_ID;
in integer IN_Object_Type;

local integer l_Exp_Error, l_Dict, l_Sequence;
local string l_Table, l_Field;

if IN_Object_Dict_ID = IG_PROD_ID then
	case IN_Object_Type
		in [SMARTLIST_OBJECTTYPE_LEADS]
			l_Table = "IG_Leads_MSTR";
			l_Dict = IG_PROD_ID;
			l_Field = "Lead ID";
			call with name "Explorer_Set_SQL_Query_Field" in dictionary SMARTLIST,
				l_Sequence,
				l_Table,
				l_Dict,
				l_Field,
				l_Exp_Error;
	end case;
end if;


Documentation Feedback