On Sun, 21 Jul 2013 03:03:10 +0530, "V.Krishn" <vkris...@gmail.com> wrote:
>following works: >attach database 'file:test.db' as 'test'; #OK >select * from test.employees limit 1; #OK > >but, >attach database 'file:test.db' as '123test'; #OK >select * from 123test.employees limit 1; #Gives error > >I hope this is not a bug ? >(assuming here that table names starting with numeric is not allowed). The filename is in a literal, the identifier is not. Indeed identifiers should not start with a digit. So, drop the quoting in the identifier. attach database 'file:test.db' as test; -- OK attach database 'file:test.db' as 123test; -- not OK attach database 'file:test.db' as test123; -- OK Note: these are database names, not table names. A double quoted database identifier as in "123test" might work (or not, you can test that easily), but why bother? -- Groet, Cordialement, Pozdrawiam, Regards, Kees Nuyt _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users