Subject Re: [ib-support] [] or ""
Author Ivan Prenosil
> It would be my contention that it should only really effect the SQL
> parser code since it would be there that table and field names would be
> tested for validity, no? Or would the concern be more for the actual field
> name issues involved using special characters and not necessarily for the
> delimiting of those names in an SQL statement?

Currently there is problem how to show database structure.
If table name is e.g.
MyTable
you know that there are lowercase letters so the output must look like
"MyTable"
But if table name is
MYTABLE
should it be shown as MYTABLE or "MYTABLE" ? Which one is "more correct" ?

Now imagine you implement "bracket delimiters".
Should
MYTABLE
be shown as MYTABLE or "MYTABLE" or [MYTBLE] ?
Should
MY TABLE
be shown as "MY TABLE" or [MY TABLE] ?



Ivan
http://www.volny.cz/iprenosil/interbase