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 , description TEXT ,
feature_count TEXT , Order TEXT , platform TEXT , platform_organism TEXT
, platform_technology_type TEXT , pubmed_id TEXT , reference_series TEXT
, sample_count TEXT , sample_organism TEXT , sample_type TEXT , title
TEXT , type TEXT , update_date TEXT , value_type TEXT )"
Error: near "Order": syntax error
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
