Problem/Issue 5018
 
Query for PDR ID
Example: search for PDR ID 109-9999 , just enter 9999 into the entry field and press ENTER.
Open Build: Open Date: Language:
1.80.284 16.07.2002 (All)
Closed Build: Close Date: Platform:
1.90.286 16.07.2002 ALL
State: Reference PDR ID: Hotfix Rollup No.:
CLOSED    
Symptom:
Using functions in ORDER BY expressions not possible
Description: 
Using a server-side function in an ODRER BY clause is possible, but
fails if ODBCDBE should open an index based on such an expression.
Sample:
   SELECT Substring(city,1,3) FROM Customers ORDER BY Substring(city,1,3)

It would be nice if the index would open and recognize the function.
This would at least allow to provide the function at the client side
as an UDF:

   FUNCTION Substring(c,n,l)
   RETURN Substr(c,n,l)
Solution: 
No Workaround for this problem known!
 
(C) Copyright Alaska Software Inc. 2008, All rights reserved!
Disclaimer, Limitation of Liability, no Warranty: THE INFORMATION, DOCUMENTS, FILES AND MATERIALS CONTAINED IN THIS SITE ARE PROVIDED "AS IS". ALASKA SOFTWARE DOES NOT WARRANT THE ACCURACY, ADEQUACY OR COMPLETENESS OF THIS INFORMATION AND MATERIALS; THUS EXPRESSLY DISCLAIMS LIABILITY FOR ERRORS OR OMISSIONS IN THIS INFORMATION AND MATERIALS.
WARRANTIES OF ANY KIND, IMPLIED, EXPRESSED OR STATUTORY, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF NON-INFRINGEMENT OF THIRD PARTY RIGHTS, TITLE, MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE OR RESOLVEMENT-CLAIMS, ARE DISCLAIMED.