Kbase P142196: Simple ABL query fails to run against OE10.1C03 MS SQL Server Database when a date field in not the
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
17/07/2009 |
|
Status: Verified
SYMPTOM(s):
Simple ABL query fails to run against OE10.1C03 MS SQL Server Database when a date field in not the first one on the where clause
The ABL client GPF when a simple query with Where clause contains a non-index field first and the date fields afterward
SYSTEM ERROR: Date/Time format error. (6175)
[Microsoft][SQL Native Client][SQL Server]Conversion failed when converting datetime from character string.
Stack trace from prow32.dll reads:
rcUpdateFieldMap
The sql generated for a simple where clause that gpf is as follows:
ABL query using sports2000 migrated to MS SQL Server 2005:
FIND FIRST order WHERE salesrep = "RDR" AND custnum = 53 AND orderdate = 1/26/98.
dataserv.lg file shows the following sql:
SELECT PROGRESS_RECID, "custnum", "ordernum" FROM "sp2k"."dbo"."order_" WHERE (("salesrep" = ?) AND ("custnum" = ?) AND ("orderdate" >= ? AND "salesrep" < DATEADD(DAY,1, ?))) ORDER BY "custnum", "ordernum"
FACT(s) (Environment):
Windows
OpenEdge 10.1C03 Service Pack
MS SQL DataServer
CAUSE:
Bug# OE00181560
FIX:
Upgrade to OpenEdge10.1C04, OpenEdge 10.2A01 or later