I have a command object that is not behaving properly.
When I execute the query in design mode, it runs without any problems and returns the expected records. However, when I execute it from within my app, VB appears to hang and I get nothing. The query is definitely being referenced correctly (and other similar queries run without problems), and the parameter value is correct. I've tried everything I can think of, but no luck so far, and the Microsoft KB wasn't much help. If anyone out there has a solution, I'd love to hear from you!