Contributions
Using Recordsets
I've loaded some data into a recordset using the following code: Set connDB1 = DatabaseUtils.getDBConnection(PROVIDER, DBPATH, DBNAME) rs = connDB1.execute ("SELECT * FROM TradeData WHERE ScenarioID = "& scenarioNumber) The recordset (rs) is populated correctly, however this query should return 2 rows. I would therefore expect to able to use commands like rs.eof rs.movenext etc These don't seem to be available and without them the recordset is fairly useless. How do I get them to work? I am using VBScript as my language12KViews0likes1CommentUsing 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).value11KViews0likes1Comment