>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 square brackets? "Order" [Order] Both will work, but you'll have to use this syntax in your commands and queries. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
