Using Recordsets

[jmcdiarmid]

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 language

[jmcdiarmid]

The solution was to use this:



set  rs = connDB1.execute ("SELECT * FROM TradeData WHERE ScenarioID = "& scenarioNumber)



instead of this



rs = connDB1.execute ("SELECT * FROM TradeData WHERE ScenarioID = "& scenarioNumber)