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