Re: [sqlite] Newbie problem using special column name

2010-01-25 Thread Patrick Ben Koetter
sql. You will have to make sure that you enclose the > column name every time you (or somone other) uses ist. Thanks. Unfortunately I don't have a choice. An application I don't have control over expects such strange table names. p...@rick > > Martin > > Patrick Ben Koe

[sqlite] Newbie problem using special column name

2010-01-25 Thread Patrick Ben Koetter
Can I add a column name containing a dash "-" and if yes, how would I do that? I am asking because I fail to add a column name that contains a dash "-" and I don't know if I cause the problem (easy solution) or if its something else causing this to fail. Here's what I try: sqlite> create