Forum Discussion
What did you use to run the query? Did you use ADO connection object?
- Colin_McCrae9 years agoCommunity Hero
Assuming you've used an ADO connection to run the query, you should be getting a recordset object back if the query runs successfully.
https://msdn.microsoft.com/en-us/library/ms681510(v=vs.85).aspx
Personally, I find it easier to dump the field values into an array and pass them back that way. Recordset objects are bit klunky in terms of their handling. However, you may sometimes need to go through it field by field. Depends on the data types and what you want to do with them. For example, if I get a field back thats a bit (bool) type, it returns "0" as a string for FALSE (fine), but you get "-1" (or "not zero") back for a TRUE. Which is not ideal as viewed through SQL manager (what all our testers use), these fields show a "1" for true. So I have to check the field types before string conversion and explicity filter out the bit fields to return "1" if they are true.
Related Content
- 8 months agoḼari
- 5 years agomithunpal2
- 2 years agoDesktopapptesti
Recent Discussions
- 2 days agoMW_Didata