Kbase P114241: SQL-92: Query executed via SQL Explorer tool and Crystal Reports appears to drop the data in the "th
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
3/14/2006 |
|
Status: Unverified
FACT(s) (Environment):
Windows
Progress 9.1E
SYMPTOM(s):
Query executed via SQL Explorer tool and Crystal Reports appears to drop the data in the "thousandths" place.
An equivalent 4GL query returns data with three decimal places intact.
SQL-92
CAUSE:
SQL-92 and 4GL work correctly as expected. The difference is due to the fact that the queries were being executed against two different databases.
FIX:
Ensure that the query is executed against the correct database.