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