Associating a Custome ResultSet with a Choose From List
I have to Link the Chose from List with a UDO for accessing the records from the Parent Table /Child Table
How to crack this problem?
Also I have to associate the Results of a custom query in a choose from list so that when I press TAB over a Text Box I get a Choose From List which displays the Results and I could select one of those rows.
Plz Hint me for this Problem
Yatsea Li replied
When you create CFL, just set your UDO type with oCFLCreationParams.ObjectType = "My_UDO", the collumn to be displayed in CFL has been determined by Find Service in your UDO definition.
As per custom query, actually you can set the condition to do so. Direct customed SQL is not supported in CFL. You may refer to the SDK sample for further info after you install SDK component:
<<C:\Program Files\SAP\SAP Business One SDK\Samples\COM UI\VB.NET\17.ChooseFromList>>
Private Sub AddChooseFromList() Try Dim oCFLs As SAPbouiCOM.ChooseFromListCollection Dim oCons As SAPbouiCOM.Conditions Dim oCon As SAPbouiCOM.Condition oCFLs = oForm.ChooseFromLists Dim oCFL As SAPbouiCOM.ChooseFromList Dim oCFLCreationParams As SAPbouiCOM.ChooseFromListCreationParams oCFLCreationParams = SBO_Application.CreateObject(SAPbouiCOM.BoCreatableObjectType.cot_ChooseFromListCreationParams) ' Adding 2 CFL, one for the button and one for the edit text. oCFLCreationParams.MultiSelection = False 'Just Set your UDO type. oCFLCreationParams.ObjectType = "My_UDO" oCFLCreationParams.UniqueID = "CFL1" oCFL = oCFLs.Add(oCFLCreationParams) ' Adding Conditions to CFL1 oCons = oCFL.GetConditions() oCon = oCons.Add() oCon.Alias = "CardType" oCon.Operation = SAPbouiCOM.BoConditionOperation.co_EQUAL oCon.CondVal = "C" oCFL.SetConditions(oCons) Catch MsgBox(Err.Description) End Try End Sub