Kbase P157987: SQL NATIVE ERROR:[0],SQL ERROR[[DataDirect][ODBC OPENEDGE driver]Invalid date escape. Correct syntax
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
1/12/2010 |
|
Status: Unverified
SYMPTOM(s):
SQL NATIVE ERROR:[0],SQL ERROR[[DataDirect][ODBC OPENEDGE driver]Invalid date escape. Correct syntax is (d'yyyy-mm-dd').]
Using invalid date syntax like order.shipdate ={d 'Not Use30'}
FACT(s) (Environment):
Progress 9.x
OpenEdge 10.x
All Supported Operating Systems
CAUSE:
Invalid SQL syntax
FIX:
Use the following syntax for a date value:
{d 'yyyy-mm-dd'}