Kbase P13537: When creating a table from an SQL session, can the fields properties default setting of
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
19/11/2008 |
|
Status: Verified
GOAL:
When creating a table from an SQL session, can the fields properties default setting of "case-sensitive" be changed or not selected?
FACT(s) (Environment):
All Supported Operating Systems
Progress 9.x
OpenEdge 10.x
FIX:
By the SQL92 standard, column definitions in SQL are case-sensitive.
The SQL engine has the ability to read case insensitive columns from the
4GL, and properly query them. However, when creating a SQL table, the only choice you have is "case-sensitive".