Problem/Issue 4511
 
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.261 27.07.2001 (All)
Closed Build: Close Date: Platform:
1.90.287 27.08.2002 ALL
State: Reference PDR ID: Hotfix Rollup No.:
CLOSED    
Symptom:
ODBCDBE cannot read from SQL server if SMALLDATETIME is used
Description: 
Using MS-SQL server and a table having a field of type
SMALLDATETIME does not work. The error is
"Error while reading".
Solution: 
Either try to use DATETIME or TIMESTAMP or, alternatively,
open the table by casting in the SELECT statement:

SQL "SELECT cast(f1 as datetime) AS F1 from sdt"

Another option is to set
 oSession:setProperty(ODBCSSN_TIMESTAMP_AS_DATE, .t.)
prior to executing the query. Now the smalldatetime column
is exposed as a Field of type DATE.
 
(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.