SBO 2005 problem in DBDataSource InsertRecord

[Former Member]

Hello all,

My add on runs on 2004 version, but when I try it with 2005 version, it does not work. When I

oDBDataSource2.Query(oConditions1)

oDBDataSource2.InsertRecord(oDBDataSource2.Size)

oMatrix1.LoadFromDataSource()

oMatrix1.Columns.Item("Concepto").Cells.Item(1).Click()

With this code, the oMatrix1.LoadFromDataSource() method does not load any record, while i see the dbdatasource record count is >0. I think it is because the instruction "oDBDataSource2.InsertRecord(oDBDataSource2.Size)", because when I comment it, it runs well, but i don't have the blank line at the end of the matrix.

The SBO Version is 2005 PL 04

Is there someone who can help me please ?

Thks for your help

[rasmuswulff_jensen · Accepted solution]

First of all: Please upgrade to a patchlevel higher than PL04 since it contains some nasty bugs in the SDK (and also PL04 is rampup... PL05 is final)

Regarding your question:

I have had the same problem, but found the solution. in 2005A for some reason it is not enough to insert a record in order to get a new row... You also need to set a value in the new row... the following code works:

oDbds.InsertRecord(oDbds.Size);	
oDbds.SetValue(0,oDbds.Size-1,"");

Don't ask why, but it is needed from 2005A (And boy did this give so much problems a few months ago)