DBInstance = "3db60a7a-6443-45ff-8ae6-d05d0d05e007"
Set AConnection = ADO.CreateADOConnection
AConnection = .CreateADOConnection
AConnection.ConnectionString = "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog="+DBInstance+";Data Source=.\eaudit"
AConnection.LoginPrompt = False
QueryText = "SELECT count(*) FROM dbo.tablename"
Set RecSet = AConnection.Execute_(QueryText)
RecSet = AConnection.Execute_(QueryText)
Getcount = RecSet.recordcount
Im not able to get the correct record count in this. I get the anser as 1 instead of 4
[Hall of Fame]
Please consider giving a Kudo if I write good stuff
Why automate? I do automated testing because there's only so much a human being can do and remain healthy. Sleep is a requirement. So, while people sleep, automation that I create does what I've described above in order to make sure that nothing gets past the final defense of the testing group.
I love good food, good books, good friends, and good fun.
Mysterious Gremlin Master
Vegas Thrill Rider
Do you know the command to retrieve the value. When i execute the same query, i dont get the column name so i cannot use