On Thu, Apr 05, 2012 at 12:18:30PM -0400, inq1ltd scratched on the wall: > > sqlite help, > > I have a program that is complete and in testing. > > In testing we found that sqlite complains if a > table is named using a leading text numeral. > > For example I can't name a table "12-0401". > I haven't seen anything in the sqlite create table > info about not using a name such as this. > > Is there any way around this?
Quote the table name in all SQL statements. Table names are identifiers, so double-quotes are best: http://www.sqlite.org/lang_keywords.html -j -- Jay A. Kreibich < J A Y @ K R E I B I.C H > "Intelligence is like underwear: it is important that you have it, but showing it to the wrong people has the tendency to make them feel uncomfortable." -- Angela Johnson _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
