Forum Discussion

jmcdiarmid's avatar
jmcdiarmid
New Contributor
14 years ago

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










1 Reply

  • Hi,



    What happens when you execute the code from your second example? Do you get any errors? If you do, what is their text?



    BTW, what scripting language are you using? If it is JScript, keep in mind that it is case-sensitive, and you need to spell the Item property name correctly (with capital I).