If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
What character(s) is(are) used to preface comments in Access SQL?
I want to accomplish as simple task - adding comments in my sql so that it
is documented. Nowhere can I find this in the MS documentation or via a web search. Thanks much! |
#2
|
|||
|
|||
What character(s) is(are) used to preface comments in Access SQL?
To comment out a line use ' type your documentation.
-- Milton Purdy ACCESS State of Arkansas "John" wrote: I want to accomplish as simple task - adding comments in my sql so that it is documented. Nowhere can I find this in the MS documentation or via a web search. Thanks much! |
#3
|
|||
|
|||
What character(s) is(are) used to preface comments in Access SQL?
Access doesn't allow comments in your SQL :-(
-- Duane Hookom Microsoft Access MVP "John" wrote: I want to accomplish as simple task - adding comments in my sql so that it is documented. Nowhere can I find this in the MS documentation or via a web search. Thanks much! |
#4
|
|||
|
|||
What character(s) is(are) used to preface comments in AccessSQL?
Access DOES NOT support embedded comments in the SQL string.
You can in query design view use the description properties of the fields and the query to do some documentation. And you can embed (as calculated fields) text strings to use a comments. Yeah! That's really, really ugly and a performance drag. John Spencer Access MVP 2002-2005, 2007-2009 The Hilltop Institute University of Maryland Baltimore County golfinray wrote: To comment out a line use ' type your documentation. |
#5
|
|||
|
|||
What character(s) is(are) used to preface comments in Access SQL?
That's VBA code, not Access SQL.
golfinray wrote: To comment out a line use ' type your documentation. -- Milton Purdy ACCESS State of Arkansas "John" wrote: I want to accomplish as simple task - adding comments in my sql so that it is documented. Nowhere can I find this in the MS documentation or via a web search. Thanks much! -- HTH, Bob Barrows |
Thread Tools | |
Display Modes | |
|
|