Problem/Issue 4979
 
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.70.267 24.06.2002 (All)
Closed Build: Close Date: Platform:
1.90.287 07.10.2002 WIN32
State: Reference PDR ID: Hotfix Rollup No.:
CLOSED    
Symptom:
ODBCDBE can not handle indexes with mixed datatypes
Description: 
Using an SQL table with ORDER BY where the fields are having different
data types, for example a character and a numeric field, the application
is crashing.
Solution: 
Use the CAST command to convert the fields to an unique datatype,
for example
...
DbCreate(cTbl, {{"ID", "C", 10, 0}, {"WHAT", "N", 8, 2}})
...
USE ("SELECT id, cast(what AS character) AS c_what FROM "+;
         "casttest ORDER BY id, c_what;")

If the backend does not support CAST, it might support CONVERT:

USE ("SELECT id, CONVERT(what, SQL_CHAR) AS c_what FROM "+;
         "casttest ORDER BY id, c_what;")
 
(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.