|
||||||
| Database & Database Programming MySQL, Oracle, SQL, PL/SQL, ABAP, Smart Forms, and other databases and languages. A database is an organized body of related information used in many websites (including CC). |
![]() |
|
|
LinkBack | Thread Tools | Search this Thread | Display Modes |
|
|||
|
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! |
| Sponsored Links |
|
|
![]() |
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Adding a calculated column to a table | reachpradeep | Database & Database Programming | 0 | 03-05-2007 07:13 AM |
| Xav | ........ | 1323.18 |
| MeTh0Dz|Reb0rn | ........ | 1053.7 |
| morefood2001 | ........ | 879.43 |
| John | ........ | 877.37 |
| marwex89 | ........ | 869.98 |
| WingedPanther | ........ | 840.94 |
| Brandon W | ........ | 750.07 |
| chili5 | ........ | 310.39 |
| Steve.L | ........ | 241.84 |
| dcs | ........ | 216.02 |
Goal: 100,000 Posts
Complete: 82%