Kbase 15087: How to fix error 85 223 on date fields in ESQL application
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
5/10/1998 |
|
How to fix error 85 223 on date fields in ESQL application
Error 85 or 223 may occur when referring to a
date in an ESQL application.
For instance, the following code may cause either
of the above errors:
select name,cust-num from customer
where birth\-date > 09/09/90;
It is necessary to put a '\` before the '/' or the
date will be interpreted differently by the pre-processor.
The code should look like:
select name,cust-num from customer
where birth\-date > 09\/09\/90;
Progress Software Technical Support Note # 15087