JamieBrydges
New Contributor
Joined 9 years ago
User Profile
User Widgets
Contributions
How do i return a table from a sql server query using Testcomplete?
Hi, i'm trying to return a table from a sql server query. I have the folowing method but when i look at the results that are return i get the error = error: cannot perfom this operation on a closed dataset: function ReturnSqlQuery(sqlQuery, connectionString) { try { var query = ADO.CreateADOQuery(); query.ConnectionString = connectionString; query.SQL = sqlQuery; query.Open(); var queryResult = query; return queryResult; } finally { Log.Message("Closing the connection."); query.Close(); } }Solved2.2KViews0likes3Comments