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...
Forum Discussion
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)
set rs = connDB1.execute ("SELECT * FROM TradeData WHERE ScenarioID = "& scenarioNumber)
instead of this
rs = connDB1.execute ("SELECT * FROM TradeData WHERE ScenarioID = "& scenarioNumber)
