Linker IT Software
Google
Web www.oraxcel.com
menubar-top-links menubar-top-rechts
Home Help Search Login
Welcome, Guest. Please Login.
SQL*XL: Database to Excel bridge litLIB: Excel power functions pack ExcelLock: Locking and securing your valuable Excel spreadsheets encOffice: Protect your Excel file easy and safe encOffice: Protect your Excel file easy and safe
Pages: 1
Support for -- comments (Read 4600 times)
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
Support for -- comments
09.11.05 at 12:09:45
 
Support for comment lines was added to SQL*XL. You can now add code lines in your SQL. For example:
select * --all columns
from emp;
 
Note that you need to put the rest of the SQL on the next line. A -- means that all characters to the end of the line are to be considered as a comment. The following line is therefore not a valid SQL statement:
select * --all columns from emp;
 
These comments can be handy if you are constructing SQL. You can comment SQL lines out for later use. Example:
select empno
,  deptno
--, hiredate
, sal
from emp where empno = 123
-- and deptno = 20
 
This feature will be released in SQL*XL version 4.0.28
Back to top
 
 

Gerrit-Jan Linker
Linker IT Software
Email WWW Gerrit-Jan Linker   IP Logged
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
Re: Support for -- comments
Reply #1 - 01.02.06 at 15:30:25
 
There remained some problems with -- comments. I have recoded it partly. SQL*XL can now also cope with end of line -- comments where there is some syntax before the comment.  
 
The test SQL that is working ok now is:

-- this is a first comment line
select * -- first end of line comment
-- the first full line comment
from emp -- second end of line comment
-- the last comment

 
Available in SQL*XL 4.0.39
Back to top
 
« Last Edit: 01.02.06 at 15:31:02 by Gerrit-Jan Linker »  

Gerrit-Jan Linker
Linker IT Software
Email WWW Gerrit-Jan Linker   IP Logged
Pages: 1