RichardRahl
Programmer
In most DBMS's I've used, you can create Tables and Columns with names
enclosed in quotes which can include special characters and is case
sensitive. Using SQL (both natively and from ODBC), you usually have
to include the quotes in the call (i.e. SELECT "I,D 1" FROM "I,AM A
Special Table"
This is fine, but when using SQLTables (from the ODBC API, to get a list of tables, ODBC gives you NO indication that the table is "special", and needs quotes in its table name when used in SQL. The table name returned by
SQLTables contains all the special characters, but without the quotes!
This is a big problem. Does anyone know how to determine if a table or
column is a "special" (quoted) one?
Thanks!
enclosed in quotes which can include special characters and is case
sensitive. Using SQL (both natively and from ODBC), you usually have
to include the quotes in the call (i.e. SELECT "I,D 1" FROM "I,AM A
Special Table"
This is fine, but when using SQLTables (from the ODBC API, to get a list of tables, ODBC gives you NO indication that the table is "special", and needs quotes in its table name when used in SQL. The table name returned by
SQLTables contains all the special characters, but without the quotes!
This is a big problem. Does anyone know how to determine if a table or
column is a "special" (quoted) one?
Thanks!