|
| 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
February 22nd, 2010, 06:23 PM
posted to microsoft.public.access.queries
|
|||
|
|||
Commenting in SQL
Is there any "comment" characters I can use in SQL which will be ignored,
similar to HTML's !-- comment -- ? VWP1 
|
|
#2
February 22nd, 2010, 06:35 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
Commenting in SQL
Unfortunately not in Access. I have heard of some comvoluted workarounds such
as running the SQL in code where you can make it happen. -- Jerry Whittle, Microsoft Access MVP Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder. "VWP1" wrote: Is there any "comment" characters I can use in SQL which will be ignored, similar to HTML's !-- comment -- ? VWP1
|
|
#3
February 22nd, 2010, 09:22 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
Commenting in SQL
On Mon, 22 Feb 2010 10:23:01 -0800, VWP1
wrote: Is there any "comment" characters I can use in SQL which will be ignored, similar to HTML's !-- comment -- ? VWP1 We've been yelling at MS for years to add this feature, but... at present, no. About all you can do is a snarky getaround: creating a phony calculated field, e.g. SELECT "This isn't a real field, just a comment" AS IgnoreThis, other fields FROM mytable... -- John W. Vinson [MVP]
|
|
#4
February 22nd, 2010, 09:34 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
Commenting in SQL
"John W. Vinson" wrote in message
... On Mon, 22 Feb 2010 10:23:01 -0800, VWP1 wrote: Is there any "comment" characters I can use in SQL which will be ignored, similar to HTML's !-- comment -- ? VWP1 We've been yelling at MS for years to add this feature, but... at present, no. Yes, come to think of it is something I've been forgetting to yell about! About all you can do is a snarky getaround: creating a phony calculated field, e.g. SELECT "This isn't a real field, just a comment" AS IgnoreThis, other fields FROM mytable... Well, at least I can say I'm very proud of you, since you've added the word snarky to above statement. (no question, the above is a last chance saloon type of solution). -- Albert D. Kallal (Access MVP) Edmonton, Alberta Canada
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
