Using the ODT Data functionality
I have worked out how to set the data value on the fly using the following command:
ODT.data.MBOSTradeData.Variables(rs.item(y).name) = rs.item(y).value
where rs is recordset loaded from a database query. This works perfectly (and effectively mimics the functionality offered by Reflections in Java), however, if I need to know how to access the items aspect of the object if you set it to an array instead of a basic data store.
It should look like this, but doesn't work:
ODT.data.MBOSTradeData.Variables(rs.item(y).name).items(0) = rs.item(y).value
ODT.data.MBOSTradeData.Variables(rs.item(y).name) = rs.item(y).value
where rs is recordset loaded from a database query. This works perfectly (and effectively mimics the functionality offered by Reflections in Java), however, if I need to know how to access the items aspect of the object if you set it to an array instead of a basic data store.
It should look like this, but doesn't work:
ODT.data.MBOSTradeData.Variables(rs.item(y).name).items(0) = rs.item(y).value
