Skip to Content
0
Former Member
Jul 02, 2007 at 09:59 AM

combo in matrix

12 Views

Hi,

When I try to list the combo in matrix, it is throwing error as follows.

"Thread was being stopped"

I use the following coding instead of using SBO business objects,

Declaration

Private colstcode As SAPbouiCOM.Column

Calling the function

AddshiftToCombo(colstcode)

Private Sub AddshiftToCombo(ByVal oColumn As SAPbouiCOM.Column)

Dim RS As SAPbobsCOM.Recordset

Dim Bob As SAPbobsCOM.SBObob

Try

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

RS.DoQuery("SELECT Code, U_Sdescr FROM [dbo].[@PSSIT_OSFT1]")

RS.MoveFirst()

While RS.EoF = False

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

RS.MoveNext()

End While

Catch ex As Exception

MessageBox.Show(ex.Message)

End Try

End Sub

I used, user defined table.

Let me the solution please to overcome this problem.

Thanks a lot in advance.

Venkatesan G.