AgiRowCursor setProperty doesn't work in MS SQL Server 2000?

[garyyeung]

Dear All,

We are using SilverStream 3.75 with MS SQL Server 2000 as DB. We create a page with a AgpViewPanel. We bind the labels of the AgpViewPanel with a AgpData.

Under rowGenerateBegin of the View, we add logics to calculate something and set one of the columns with new data.

/******************

AgiRowCursor rc = (AgiRowCursor)view.getCurrentRowCursor();
rc.setProperty("COL", "Test"

/******************

The Column "COL" cannot display "Test".

The same piece of code works fine in Oracle 8i. Any suggestions or work-arounds?

Thanks in advance,
Gary