On Sunday, July 21, 2013 04:50:16 AM Igor Tandetnik wrote: > On 7/20/2013 5:33 PM, V.Krishn 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 > > Try > > select * from "123test".employees limit 1;
Thanks, this works. Reason for naming identifier starting with a digit was I have archived databases and wanted to attach them using date like '1305' for creating some reports. I think, to keep things simple, I would leave the quotes out and add a string (eg. d1305). > > A name that's not a valid identifier (a sequence of letters and digits > beginning with a letter) should be enclosed in double quotes. -- Regards. V.Krishn _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users