Questions

Answer for:

SQL Statement in VB6 Code

Message 7 of 12

View entire thread
+
0 Votes
navanax

When you get done building the query string, display it (or put a breakpoint in and copy it's contents) and check it. It's not only easier to spot problems with quotation marks (unbalanced, missing, mismatched) but you can also paste the string into your favorite query client and "play" with it there until you have the correct query, then go back to make the fixes in your code.