SAPbobsCOM.Recordset rs = (SAPbobsCOM.Recordset)B1Connections.diCompany.GetBusinessObject(SAPbobsCOM.BoObjectTypes.BoRecordset); var sql = @" SELECT OHEM.empID FROM OHEM INNER JOIN HEM6 ON OHEM.empID = HEM6.empID WHERE HEM6.roleID = '{0}' "; try { SAPbouiCOM.ChooseFromListCollection oCFLs = null; SAPbouiCOM.Conditions oCons = null; SAPbouiCOM.Condition oCon = null; oCFLs = form.ChooseFromLists; SAPbouiCOM.ChooseFromList oCFL = null; SAPbouiCOM.ChooseFromListCreationParams oCFLCreationParams = null; oCFLCreationParams = ((SAPbouiCOM.ChooseFromListCreationParams)(B1Connections.theAppl.CreateObject(SAPbouiCOM.BoCreatableObjectType.cot_ChooseFromListCreationParams))); oCFLCreationParams.MultiSelection = false; oCFLCreationParams.ObjectType = "171"; // EmployeesInfo object oCFLCreationParams.UniqueID = ChooseFromList_technician; oCFL = oCFLs.Add(oCFLCreationParams); oCons = oCFL.GetConditions(); rs.DoQuery(String.Format(sql, Properties.Settings.Default.HEM6_rolerID)); var count = rs.RecordCount; while (!rs.EoF) { oCon = oCons.Add(); oCon.Alias = "empID"; oCon.Operation = SAPbouiCOM.BoConditionOperation.co_EQUAL; oCon.CondVal = rs.Fields.Item("empID").Value.ToString(); oCFL.SetConditions(oCons); if ((count--) > 1) oCon.Relationship = BoConditionRelationship.cr_OR; rs.MoveNext(); } } catch (Exception ex) { B1Connections.theAppl.MessageBox("Erro na criação do CFL : " + ex.Message); }