In Oracle, quoting a column name in SQL makes the column name case sensitive. The Oracle SQL parser translates unquoted column names to uppercase. If the column names in the table are not uppercase, quote all references to column names in field and query mappings for a component to ensure the names match the actual column names after the queries are parsed. If you are using EAServer automatic table creation, all column references must be consistent in the use of quotes and letter case.
| Copyright © 2005. Sybase Inc. All rights reserved. |
|
|
