My Assistant
Site Message
(Message will auto close in 2 seconds)
  |
 Using comments in access sql code?
|
|
 Jul 9 2004, 08:50 AM
Post
#1
|
|
|
UtterAccess Member Posts: 29  |
Can comments be added to sql code?
Would be handy for debugging so I can comment out sections to see where a problem is... Thanks. |
 |
 
|
|
Jul 9 2004, 08:53 AM
Post
#2
|
|
|
UtterAccess VIP Posts: 3,667 From: Toronto, ON |
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
Post
#3
|
|
|
UtterAccess Member Posts: 29 |
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
Post
#4
|
|
|
UtterAccess VIP Posts: 3,667 From: Toronto, ON |
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 |
|
|
|
 |
|
Jump To Forum:
|
Go to Top · Lo-Fi Version | Time is now: 25th May 2013 - 03:33 AM |
Tag cloud: