Jul 9 2004, 08:50 AM
Can comments be added to sql code?
Would be handy for debugging so I can comment out sections to see where a problem is...
Jul 9 2004, 08:53 AM
you cannot insert comment inside the SQL string, but for sure you can add comments before or after.
also you can comment out portion of your code, if needed.
To comment out a code line - use ' in front of the line
Jul 9 2004, 09:07 AM
Thanks for your response but that doesn't work within my sql query. I know it works for vba code. I get errors if I try to enter a comment line in my sql query. I am using access 2000 if that helps.
Jul 9 2004, 09:12 AM
as I said before, you cannot inser comment inside SQL statement.
it looks you are talking about saved queries, so an idea it would be to use query Description for additional comments
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here