On Tue, Aug 30, 2011 at 9:25 AM, Simon Slavin <slav...@bigfraud.org> wrote:

> I'm writing an app which generates text files intended for reading by the
> shell tool's '.read' command.  We're using SQL text files because I'm
> writing a design which needs to be completely open, understandable, and
> easily hackable by third parties.
>
> I want to include comments in my SQL files.  The following page
>
> <http://www.sqlite.org/lang_comment.html>
>
> suggests I can use lines that begin with two consecutive "-" characters
> (ASCII 0x2d).  I have done some exploration to find out how the current
> version of the shell tool handles '<newline>--' inside quotes, inside
> statements, etc. but since it's not documented I can't be sure future
> versions will last the same way.
>
> Is anyone aware of any problems with this ?  Any problems with multi-line
> quoted text strings containing comments ?  Anything else anyone wants to
> warn me about ?  I don't actually need to use the '/*' format, but if anyone
> wants to talk about that, that's cool too.
>

Strings that contain comment-like characters are not altered in any way -
the comment-like characters are preserved.  The sqlite3_complete() routine
takes care of this on behalf of the shell.


>
> Simon.
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>



-- 
D. Richard Hipp
d...@sqlite.org
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to