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