TIP: comments in SQL

[Ruslan Zasukhin]

Hi all,

I want show you new TIP which you can use in 2.0.

Btw, please read latest VSQL.pdf
It have grammar of our new SQL.

So, COMMENTS.

Valentina 2.0 allow you next comments in SQL query

        -- SQL92 single line comment

        // single line as in C++
        
        /* multi
            line 
                comments as in C */


------------
This is very comfortable when you work in viSQL or Vstudio.

select 
       authorsSortMethod, thedateSortMethod
from 
    thereferences 
where 
   hit>0 
// ORDER BY authorsSortMethod,thedateSortMethod


You have comment only one line, and you get new results.


-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------