how to set and get subcolumn in spread table(mmtx.ocx) [message #86118] |
Wed, 01 September 2004 21:31  |
zhangrui
Messages: 37 Registered: March 2003
|
Member |
|
|
DECLARE
NEW_COL OLEOBJ;
COL_COUNT number;
NameArray OleVar ;
BEGIN
COL_COUNT := ORACLESPREADTABLE_DMMTX.ColumnCount(:ITEM('OCXBLK.OCXITM').interface);
--Add Sub Column
OracleSpreadTable_IColumn.AddSubColumns(NEW_COL,FORMS_OLE.To_variant('1 , 3 , 2', vtype=>VT_BSTR));
--Get the column count
:OCXBLK.NUMCOLUMN := ORACLESPREADTABLE_DMMTX.ColumnCount(:ITEM('OCXBLK.OCXITM').interface);
END;
|
|
|
|