cancel
Showing results for 
Search instead for 
Did you mean: 

Using Recordsets

Highlighted
New Contributor

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 language


1 REPLY 1
Highlighted
New Contributor

RE: Using Recordsets

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)
New Here?
Join us and watch the welcome video:
Announcements
Script Wanted
Let's start July with new challenges!

Create a script to pass custom command-line arguments as a test parameter for the TechCorner tag!

Will you dare to take the challenge?


Top Kudoed Authors