Comment Lines in MS Access SQL

  • Thread starter Thread starter Don_G
  • Start date Start date
D

Don_G

I am writing SQL statements in MS Access 2000. I would like to "comment
out" a statement.

/* sql stmt */ does not work.

Preceeding the line with -- (two dashes) does not work either. How can I
"comment out" an SQL statement?

(If you prefer to reply to my e-mail remove NOSPAM from the return address.)
 
You can't. Neither can you highlight the part you want to execute.
Save the SQL in a text file with comments if you need to.

-Dorian
 
Oh wouldn't that be nice! I do it all the time with Oracle.

I believe that there was a discussion about it around a year ago. There were
some convoluted ways of doing it, but none were easy or practical. So in a
nutshell, not in Access.
 
I am writing SQL statements in MS Access 2000. I would like to "comment
out" a statement.

/* sql stmt */ does not work.

Preceeding the line with -- (two dashes) does not work either. How can I
"comment out" an SQL statement?

(If you prefer to reply to my e-mail remove NOSPAM from the return address.)
Click to expand...

Access/Jet SQL has no syntax for comments :(

Jamie.

--
 
Back
Top