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 when creating a table if I enclose the column name in quotes, 
eg:

CREATE TABLE People('Name First', 'Name Last')

And getting the list of column names works fine. But select statements don't 
seem to work if the column names have spaces.

So, are spaces allowed or not? Is there a specification somewhere that shows 
what characters, length etc are allowed in column names (and table names)?

Thanks,
Tom
T&B


-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------

Reply via email to