I binding temporary table to dbtreview control. The code what I attached below works except it not show any data in column which I created using createColumn method of dbtreview control. This method require a server name and table name. Because my temporary table is memory table the getDataSourceServerName and getDataSourceTableName functions always return null and I think this is a cause of problem. Is it possible to extend feature of dbtreeview control to allow add columns using temporary table?
var _arrField = new Array(“itemid”, “parentid”,“item_desc”);
var _arrType = new Array(JSColumn.INTEGER, JSColumn.INTEGER, JSColumn.TEXT);
var _dset = scopes.ordNav.CreateEmptyDataSet(_arrField, _arrType);
var _dset = databaseManager.createEmptyDataSet()
_dset.addColumn(_aFields[0], 1, _aType[0])
_dset.addColumn(_aFields[1], 2, _aType[1])
_dset.addColumn(_aFields[2], 3, _aType[2])
var _dataSourceName = application.getUUID().toString()
_dataSource = _dset.createDataSource( _dataSourceName);
var rel = solutionModel.newRelation(‘myRelation’,_dataSource, _dataSource, JSRelation.INNER_JOIN);
rel.initialSort = ‘itemid asc’ // ‘sortseq asc’;
rel.allowCreationRelatedRecords = true;
rel.allowParentDeleteWhenHavingRelatedRecords = true;
rel.newRelationItem(‘itemid’, ‘=’, ‘parentid’);
_foundset.loadAllRecords()
var _server_datasource = databaseManager.getDataSourceServerName(_dataSource);
var _tableName = databaseManager.getDataSourceTableName(_dataSource);
var binding = elements.dbtreeview.createBinding(_dataSource);
binding.setNRelationName(‘myRelation’);
binding.setTextDataprovider(‘itemid’);
elements.dbtreeview.createColumn(_server_datasource, _tableName, ‘Item desc’, ‘item_desc’);
binding.setCallBackInfo(node_selected, ‘itemid’);
refreshTreeView();