Kbase P20275: Character data types in tables created via SQL-92 causing incompatibility with 4GL.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
09/06/2005 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.1D
SYMPTOM(s):
Tables created via SQL-92
Owner is set to PUB
Tables visible to both 4GL and SQL-92
Can't retrieve data from a 4gl client after inserting data.
Auto-commit is turned on
CAUSE:
SQL-92 Character Datatypes are not compatible with Progress Character types.
FIX:
For compatibility between SQL-92 and 4GL, create character fields in the SQL Explorer with varchar().