There may be a documentation bug
According to http://sqlite.org/lang_attach.html
the format of the attach command is
ATTACH [DATABASE] <filename> AS <dbname>
Jay reports below that the filename can be an expression.
Looks like the documentation needs to be clarified.
REQUEST: Add explanation to Syntax Diagrams For SQLite showing
what the legal values are for the non bolded bubbles
Regards,
Noah
-----Original Message-----
>
> I know that the work-a-round is to enter the filename in quotes.
>
> My question is why is the attach statement parsing for a column at
all.
The format of the ATTACH command is:
ATTACH [DATABASE] <expression> AS <dbname>
It happens that the expression needs to be a text value for the
command to work properly, but the parser doesn't know that.
A bare character-string given as an expression is considered a
column reference (consider SELECT or WHERE clauses). However,
the ATTACH command has no table/column context, so the column
name is unresolved, i.e. no such column.
<SNIP>
-j
--
Jay A. Kreibich < J A Y @ K R E I B I.C H >
CONFIDENTIALITY NOTICE:
This message may contain confidential and/or privileged information. If you are
not the addressee or authorized to receive this for the addressee, you must not
use, copy, disclose, or take any action based on this message or any
information herein. If you have received this message in error, please advise
the sender immediately by reply e-mail and delete this message. Thank you for
your cooperation.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
