Re: [sqlite] format for column names

2006-08-30 Thread Martin Jenkins
Nikki Locke wrote: JOOI, were you on CIX? Still am. Thought the name was familiar. I don't get on much these days. :-/ Martin - To unsubscribe, send email to [EMAIL PROTECTED]

Re: [sqlite] format for column names

2006-08-30 Thread Nikki Locke
Martin Jenkins wrote: > Nikki Locke wrote: > > Martin Jenkins wrote: > > Using [] is a Microsoft thing. More portable to use double quotes... > > Thanks, I didn't know that. I avoid spaces in column names so I haven't > actually use it in anger. > > JOOI, were you on CIX? Still am. --

Re: [sqlite] format for column names

2006-08-30 Thread Martin Jenkins
Nikki Locke wrote: Martin Jenkins wrote: Using [] is a Microsoft thing. More portable to use double quotes... Thanks, I didn't know that. I avoid spaces in column names so I haven't actually use it in anger. JOOI, were you on CIX? Martin

Re: [sqlite] format for column names

2006-08-30 Thread Martin Jenkins
T wrote: Hi all, I've just joined this mail list. I've read through the syntax page and other sources as to how to create a table using SQLite, and it's all working fine. But I can't find any specifications for the format of a column name. Does the spec permit spaces in the name? It seems to

[sqlite] format for column names

2006-08-29 Thread T
Hi all, I've just joined this mail list. I've read through the syntax page and other sources as to how to create a table using SQLite, and it's all working fine. But I can't find any specifications for the format of a column name. Does the spec permit spaces in the name? It seems to work OK