Skip to Content
0
Former Member
Oct 07, 2005 at 04:21 PM

Matrix not updating in SBO 2004

24 Views

Hi

I have a matrix with a DBDatasource tied to it. I have a total column at the end of the matrix which I want to update with the total for that line. This doesn't seem to be working. I am running this on the lost_focus event.

I have included the code below, can anyone suggest why it may not be updating please ?

Regards Andy

            For lc = 1 To nodays
              tot = CCur(tot + Val(omatrix.Columns(lc).Cells(pVal.Row).Specific.String))
            Next
            
            omatrix.GetLineData (pVal.Row)
            oform.DataSources.DBDataSources(0).SetValue "u_total", pVal.Row - 1, tot
            omatrix.SetLineData (pVal.Row)