Commenting SQL Queries

K

Kyle B.

I'm a summer-hire writing databases for my employer. I have the slight problem that no-one in my group knows anything about Access and I'll be leaving in 3 weeks. I'd like to document what's going on in a SQL query I just modified, but Access doesn't recognize two hyphens "--" or an apostrophe " ' ".

Please tell me I can add comments to SQL code, or I'll have a lynch mob after me once I return to school.
 
D

Dirk Goldgar

Kyle B. said:
I'm a summer-hire writing databases for my employer. I have the
slight problem that no-one in my group knows anything about Access
and I'll be leaving in 3 weeks. I'd like to document what's going on
in a SQL query I just modified, but Access doesn't recognize two
hyphens "--" or an apostrophe " ' ".

Please tell me I can add comments to SQL code, or I'll have a lynch
mob after me once I return to school.
Click to expand...

Better start running, Kyle. You can't add comments to SQL code in
Access. Well, actually, Stephen Lebans has found a clever workaround,
but it's rather elaborate. Have a look here:

http://www.lebans.com/addsqlcomments.htm
 
K

Kyle B.

Thanks Dirk, I was affraid of that. Skimming through the link you sent, I think I'd be better off not trying to explain that I have a script that is used to move coments in and out of the SQL code. That, and I'm sure someone would find a way to hose it up. I'll resort to the binder full of printouts with lots of handwritten notes. ... If I have time... <g>

Happy weekend,
Kyle
 
Top