query cfl problem in matrix

[Former Member]

hi all good morning.... i have one problem i assigned query cfl for matrix field. the value fetch based on header level.... the query fetch the data but its not show the CFL window..here i pasted my code

Case "matvariant"
                        Select Case pVal.ColUID
                            Case "Col_Colour"
                                Select Case pVal.EventType
                                    Case SAPbouiCOM.BoEventTypes.et_GOT_FOCUS
                                        Dim oForm As SAPbouiCOM.Form = gonAppApplication.Forms.Item("VARAINT")
                                        Dim sQuery As String = "SELECT  T1.[U_U_COLOR] FROM [dbo].[@ITEMCOLOR_DETAIL]  T0 inner join [dbo].[@ITEMCOLOR_HEADER]  T1 on t0.docentry=t1.docentry WHERE T0.[U_Itmcode] !='' and T0.[U_Avail] ='y' and T0.[U_Itmcode] = '" & oForm.Items.Item("txticode").Specific.Value & "'"
                                       oGeneral.SetConditionToCFL1(oForm, "COLITEMCFL1", "U_ID", sQuery)
                                                                           Case SAPbouiCOM.BoEventTypes.et_CHOOSE_FROM_LIST
                                        Dim bonCflEvents As SAPbouiCOM.ChooseFromListEvent
                                        Dim bonDTTable As SAPbouiCOM.DataTable
                                        Dim bonCflList As SAPbouiCOM.ChooseFromList
                                        Dim bnnstrUID As String
                                        bonCflEvents = pVal
                                        bnnstrUID = bonCflEvents.ChooseFromListUID
                                        bonDTTable = bonCflEvents.SelectedObjects
                                        bonCflList = lonConvForm.ChooseFromLists.Item(bnnstrUID)
                                        If Not (bonDTTable Is Nothing) Then
                                            If bonCflList.UniqueID = "COLITEMCFL1" Then
                                                gonMatConvMatrix.GetLineData(pVal.Row)
                                                gonMatConvMatrix.GetLineData(pVal.Row)
                                                lonDetailDatasource.SetValue("U_Col_COLOR", lonDetailDatasource.Offset, bonDTTable.GetValue("U_COLOR_NAME", 0))
                                                gonMatConvMatrix.SetLineData(pVal.Row)
                                                If pVal.Row = gonMatConvMatrix.VisualRowCount Then
                                                    lonDetailDatasource.SetValue("U_Col_COLOR", lonDetailDatasource.Offset, "")
                                                    lonDetailDatasource.SetValue("U_Col_LENGTH", lonDetailDatasource.Offset, "")
                                                    lonDetailDatasource.SetValue("U_Col_WIDTH", lonDetailDatasource.Offset, "")
                                                    lonDetailDatasource.SetValue("U_Col_THICK", lonDetailDatasource.Offset, "")
                                                    lonDetailDatasource.SetValue("U_Col_SIZE", lonDetailDatasource.Offset, "")
                                                    lonDetailDatasource.SetValue("U_Col_Desc", lonDetailDatasource.Offset, "")
                                                    lonDetailDatasource.SetValue("U_Col_Price", lonDetailDatasource.Offset, "")
                                                    lonDetailDatasource.SetValue("LineId", lonDetailDatasource.Offset, pVal.Row + 1)
                                                    gonMatConvMatrix.AddRow()
                                                    gonMatConvMatrix.SetLineData(pVal.Row + 1)
                                                    gonMatConvMatrix.FlushToDataSource()

                                                End If
                                            Else

                                            End If
                                        End If
                                End Select
                        End Select

Edited by: narain.balan on Oct 26, 2010 7:02 AM

[former_member689126]

Hi

Please post the function code oGeneral.SetConditionToCFL1(oForm, "COLITEMCFL1", "U_ID", sQuery)

I think the problem is with choose from list condition.

Regards

Arun