Skip to Content
0
Former Member
Oct 11, 2005 at 12:28 PM

Adding data to a matrix with dbdatasources in sbo 2004

157 Views

Hi

I have a matrix with dbdatasources. When I load existing data everything is fine but when I want to create a new matrix it seems to behave in an unusual way, when I click on a cell it beeps at me !

I run a query to pick up the default gl codes which I want to add to the datasource.

I have included the code below, am I doing something silly ?

Regards Andy

    ' read admin codes
    Set orecset = oCompany2.GetBusinessObject(BoRecordset)
    orecset.DoQuery ("select acctname,acctcode from oact where fathernum = '200000000000000' and finanse = 'N' and locmantran = 'N'")
    If orecset.RecordCount > 0 Then
      While Not orecset.EOF
        If orecset(1).Value <> "x" Then
            oform.DataSources.DBDataSources(0).InsertRecord lc
            oform.DataSources.DBDataSources(0).SetValue "u_contrno", lc, Left(orecset(1).Value, 10)
            oform.DataSources.DBDataSources(0).SetValue "u_contrde", lc, Left(orecset(0).Value, 10)
            oform.DataSources.DBDataSources(0).SetValue "u_gltype", lc, "1"
        End If
        orecset.MoveNext
        lc = lc + 1
      Wend