473,326 Members | 2,255 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

How to comment out lines of a query

code green
1,726 Expert 1GB
Does anybody know the syntax for commenting out lines of code in SQL View in Access Query Design?
Also how to only run one query or part of a query in SQL View when you may have 2-3 that you are playing with?

For example I can do the above in SQL Query Analyzer by
-- to comment out
and highlighting the query or part I wish to run
Jan 6 '11 #1

✓ answered by Stewart Ross

Hi code green. As far as I know Access can't do either of the things you mention. There is no provision for commenting or annotating SQL statements in SQL view at all, nor does it allow multiple SQL queries while you work on them.

The SQL view shows what really goes on under the Design View grid editor, and is bound to the SQL property of the underlying DAO QueryDef object that stores the properties for the query, hence it cannot deal with multiple independent SQL statements (other than the ones being joined or subqueried within the current QueryDef).

Sorry.

-Stewart

1 23738
Stewart Ross
2,545 Expert Mod 2GB
Hi code green. As far as I know Access can't do either of the things you mention. There is no provision for commenting or annotating SQL statements in SQL view at all, nor does it allow multiple SQL queries while you work on them.

The SQL view shows what really goes on under the Design View grid editor, and is bound to the SQL property of the underlying DAO QueryDef object that stores the properties for the query, hence it cannot deal with multiple independent SQL statements (other than the ones being joined or subqueried within the current QueryDef).

Sorry.

-Stewart
Jan 14 '11 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

5
by: Robert Spoons | last post by:
Can you look over this code, preferably try it, and comment? I believe the 'extend' function below will allow you to use full 'class inheritance' in javascript, but I would like to verify it. ...
19
by: Alex Vinokur | last post by:
Is there any tool to count C-program lines except comments? Thanks, ===================================== Alex Vinokur mailto:alexvn@connect.to http://mathforum.org/library/view/10978.html...
9
by: Tim Anderson | last post by:
Does anyone else think VB should support the // prefix for comments? I keep using it by accident, because so many other languages use it (unlike the single quote, which is I believe unique to VB)....
1
by: Reason | last post by:
Hi, Does anyone know how to run a find that excludes source lines that are totally comments? (I have used regex with good results for some other purposes, but not this one.) Stephen B.
16
by: Christopher | last post by:
Hello all, I've got a question of comment logic. I'm trying to determine if a given line of C/C++/C#/Java is a comment or not. Can you please comment on my logic. I need to define some...
1
by: gwillden | last post by:
Hello all, I'd like to propose the following change to ConfigParser.py. I won't call it a bug-fix because I don't know the relevant standards. This change will enable multiline comments as...
4
by: manickkarthik | last post by:
Hi, I want to know, How we will read the XML File Comments using PHP Code. Thaks in advance.
10
by: blackice | last post by:
Hello all this thread ihttp://www.thescripts.com/forum/thread50290.html contains what i need but i cannot understand some of the code i need more explain .... my $sampleinput = <<"EOF"; ...
2
by: Francesco Pietra | last post by:
Please, how to adapt the following script (to delete blank lines) to delete lines containing a specific word, or words? f=open("output.pdb", "r") for line in f: line=line.rstrip() if line:...
0
by: Francesco Pietra | last post by:
I forgot to add that the lines to strip are in present case of the type of the following block HETATM 7007 O WAT 446 27.622 34.356 55.205 1.00 0.00 O HETATM 7008 H1 WAT...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.