Queries randomly give error message
Both of these generate table data. Test Complete gives "Unable to display the table data. The following error occurred: The query was executed but it produced no table data." I get this a ton for no ...
Forum Discussion
How did you write it in test compelete?
without looking at you code it's not possible to comment
You're running those directly in SQL Mgmt Studio?
And these are Stored Procedures you're trying to call?
Does the second one work if you run it directly in SQL like you've shown in your screen capture? If it won't run directly, no way it'll run in TestComplete.
Can't say I know much about SQL SP's, but I do notice the first one has an owner (the "[dbo]." part) but the second one doesn't? Not sure if these are required for SQL SP's ....