Re: [sqlite] CREATE TABLE work arounds?

Thank You very much for all your responses and suggestions, they provided me with the information I needed to correct the issue. Cheers. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlit

Re: [sqlite] CREATE TABLE work arounds?

On Thu, Jun 10, 2010 at 12:12:54PM -0500, Jay A. Kreibich scratched on the wall: > On Thu, Jun 10, 2010 at 07:02:02PM +0200, Jean-Christophe Deschamps scratched > on the wall: > > > >I am parsing fields on the fly and then creating tables, > > > Can you wrap every column name inside double quot

Re: [sqlite] CREATE TABLE work arounds?

On Thu, Jun 10, 2010 at 07:02:02PM +0200, Jean-Christophe Deschamps scratched on the wall: > >I am parsing fields on the fly and then creating tables, > Can you wrap every column name inside double quotes or square brackets? > "Order" If you're using identifiers (table or column names) from

Re: [sqlite] CREATE TABLE work arounds?

>I am parsing fields on the fly and then creating tables, unfortunately >one of the fields is "Order" and is a "special word" in SQL as is not >allowed. Is there a way around this instead of intercepting with perl >s'/Order/Orders/g' Can you wrap every column name inside double quotes or squar

[sqlite] CREATE TABLE work arounds?

I am parsing fields on the fly and then creating tables, unfortunately one of the fields is "Order" and is a "special word" in SQL as is not allowed. Is there a way around this instead of intercepting with perl s'/Order/Orders/g' thanks sqlite3 DB "CREATE TABLE META (channel_count TEXT ,