From: Milan B. <albis@EUnet.yu> - 2005-11-25 10:22:58
|
Kjell Rilbe wrote: >> Can mixed-case identifiers be treated as "special" too? I can't >> imagine the >> reason to enter PrimaryID in such a field, unless one wants it quoted. >> >> And, if there already are quotes around the entered identifier, assume >> user >> knows what he is doing and pass literally? > > I object. This is the kind of counter productive AI-like logic I hate. > Too many special cases. Kjell, are you refering to mixed-case, quoted or both? I find the mixed-case case quite ok. If you really went through the trouble of holding shift for some letters, you probably want it quoted. Hm, OTOH, if someone really wants it quoted, he would select the global "always quote" anyway. As for the quoted quotes, well, I don't know anyone who would use quote characters as part of the name, do you? > If it's *really* necessary to have a conveniently accessible way of > overriding the "always quote" = off state, like in your example, I would > say that the best option is to have FR interpret a quoted name in an > input box as it would be interpreted in a SQL script. This makes sense. > In that case, what we have is: > > 1. Option off: names entered in input boxes are interpreted as if it > were written in a SQL script. If it's unquoted it will be uppercased but > reserved words and special characters will raise an error. No error raising suggestions, please. That's too intrusive and breaks the work flow. If there are special characters -> we quote them automatically. > If it's > quoted, it will be used as is (quotes stripped of course) - case is > preserved and special characters and reserved words are ok. Ok. > 2. Option on: names entered are always interpreted as is and quotes are > implicit. If the name is quoted, the name will contain those quotes > (quotes won't be stripped). If you really have only one quote at start and only one at the end, isn't it safe to assume that quotes are really quotes and not part of the name? -- Milan Babuskov http://fbexport.sourceforge.net http://www.flamerobin.org |