Kbase P69175: Getting error (7497) when executing SQL-92 query
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
15/10/2008 |
|
Status: Unverified
FACT(s) (Environment):
HP-UX 11.0
Progress 9.1D
SYMPTOM(s):
=== SQL Exception 1 ===
SQLState=HY000
ErrorCode=-20230
[JDBC Progress Driver]:Invalid date string (7497)
Executing the following select SQL-92 statement:
SELECT * FROM pub.TableName...
CAUSE:
Some date fields in the pub.TableName contain empty '' or invalid date values.
FIX:
- Either populate all date fields with valid values
or
- Change the 'SELECT *' to a SELECT <field list> to exclude the offending date fields.