Skip to Content
0
Former Member
May 09, 2008 at 07:46 AM

How the condition of combo box of matrix can be passed in query

23 Views

Hi,

I want to get the parameter code and description for a particular category. Category code is in the matrix combo box if i pass tat field in a where condition i cant retrieve the parameter code but its working in the database. Please identify the mistake and correct it.

Private Sub Addcomboparam(ByVal oCombo As SAPbouiCOM.Column)

Try

Dim RS As SAPbobsCOM.Recordset

'Dim Bob As SAPbobsCOM.SBObob

RS = Ocompany.GetBusinessObject(SAPbobsCOM.BoObjectTypes.BoRecordset)

'Bob = Ocompany.GetBusinessObject(SAPbobsCOM.BoObjectTypes.BoBridge)

RS.DoQuery("select Code,U_paradesc from [@PSSIT_QCPARAMETER] where U_catcode='" & txtcatcode.Selected.Value.ToString() & "'")

RS.MoveFirst()

While RS.EoF = False

oCombo.ValidValues.Add(RS.Fields.Item("Code").Value, RS.Fields.Item("U_paradesc").Value)

RS.MoveNext()

End While

Catch ex As Exception

MessageBox.Show(ex.Message)

End Try

End Sub

Regards,

Madhavi