Re: [sqlite] Quoting identifiers (was: Updatable views)

2008-02-11 Thread BareFeet
Puneet said: > Keep SQLite simple, and keep it compliant with whatever the single > ANSI SQL standard may be there out there. Yes, I agree, but only because it seems that SQLite's allowance for double quotes for literals (which I have said introduces ambiguity and prevents proper error

[sqlite] Quoting identifiers (was: Updatable views)

2008-02-11 Thread BareFeet
Hi Dennis, >> I use the square brackets for identifiers because I find that >> using double quotes doesn't catch errors. If I say select "column >> name that does not exist" I get a string back. But if I use square >> brackets SQLite >> gives me an error that the column doesn't exist,