Kbase P131734: ABL functions on the WHERE clause on FOR FIRST does not return any record when run against SQL Serve
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
16/07/2008 |
|
Status: Unverified
SYMPTOM(s):
ABL functions on the WHERE clause on FOR FIRST does not return any record when run against SQL Server DataServer
The query ran against sports2000 is follows:
FOR FIRST customer
WHERE ENTRY(1,NAME,"") = "Just"
NO-LOCK.
DISPLAY NAME WITH FRAME f1.
END.
The parsed SQL fro the dataserv.lg file is as follows:
SELECT TOP 1 "custnum", "country", "name", "address", "address2", "city", "state", "postalcode", "contact", "phone", "salesrep", "creditlimit", "balance", "terms", "discount", "comments", "fax", "emailaddress", PROGRESS_RECID, PROGRESS_RECID_IDENT_
FROM "customer"
ORDER BY "custnum";
FACT(s) (Environment):
ABL functions listed below are sorted on the client side when used on the WHERE clause:
Entry
replace
index
string
truncate
substring
r-index
trim
Windows NT 32 Intel/Windows 2000
OpenEdge 10.x
MS SQL DataServer
CAUSE:
Bug# OE00169041
FIX:
As a workaround use BEGINS on the WHERE clause