Can you 'commnet out' in Access 2000 SQL?

  • Thread starter Thread starter Gaijintendo
  • Start date Start date
I use a calculated field for comments like this -- "Now is the time for..."
AS [X],
 
Terry said:
Can a comment be put into Access SQL code? If it can, what format will be
valid?
Click to expand...

There are no support for comments in Access SQL code. Sorry.

The closest thing you could do is use Description property (a custom DAO
property that you would create/append, actually). You also can set it
from GUI and in Access 2003 & earlier, sort queries by the Description
property.

But if you're trying to insert MySQL code, then you're probably better
off using PTQ, without the comment anyway.
 
Terry said:
Can a comment be put into Access SQL code? If it can, what format will be
valid?
Click to expand...

Not in any normal way. Wizard Stephen Lebans did create a method to do it:

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

.... using Windows API methods and a special table to hold the comments
separately from the querydef, but it's extremely elaborate and has always
seemed like more trouble than it's worth, to me.
 
vous parler tous anglais ou koi
Click to expand...

Il s'agit d'un groupe de soutien technique pour le programme Microsoft Access.
Sa langue officielle est l'anglais. Pour un groupe français, voir
microsoft.fr.public.access.
 
Also, remember that you can add expressions to your SQL:

SELECT MB_Error_Codes.idx
, "2010/03/15 dlg"
FROM MB_Error_Codes;

(david)
 
Back
Top