Database ckeckpoint Delete query is not working with UFT GUI

  • Questions
  • Database ckeckpoint Delete query is not working with UFT GUI
Question ID: 106847
1
0

Database checkpoint Delete query is not working. The specified query cannot be executed. "Operation is not allowed when the object is closed" is displaying

Marked as spam
Posted by (Questions: 361, Answers: 39)
Asked on April 29, 2016 7:18 pm
10 views
Answers (1)
1
Private answer

The Database Checkpoint is not designed to do that type of query. You can accomplish this using VBScipt in your code. Here is the code example for execute db command:

Create a connection object
Set objDB = CreateObject(''ADODB.Connection'')

'Open a session to a db
objDB.ConnectionString = ''''
objDB.Open

'execute query
strQuery = ''Delete whatever from whatever''
Set objResults = objDB.Execute(strQuery)

'clean up
objResults.Close
objDB.Close
Set objResults = Nothing
Set objDB = Nothing

Marked as spam
Posted by (Questions: 16, Answers: 772)
Answered on April 29, 2016 7:19 pm
I should have thought of doing it that way. Thanks for the reminder.
( at April 29, 2016 7:25 pm)