View Incident Report

Serious

Reported By: Elevate Software
Reported On: 12/19/2002
For: Version 3.20 Build 1

# 1289 Using the ODBC Driver with Crystal Reports to Query on a Timestamp Field Causes an Error

Crystal Reports 8.5. I am having a problem getting the ODBC and Crystal to run date selection criteria ! For example this is what the SQL where clause within Crystal looks like when we select the date of birth field:

WHERE QuickTriage."dob" > {ts '1988-09-08 00:00:00.00'}

Comments

The ODBC driver was confusing the ts escape tag with the t (time) escape tag due to the way the parsing was done.

Resolution

Fixed Problem on 12/19/2002 in version 3.21 build 1

More Support Options

Search Incident Reports

Support Forums

Frequently Asked Questions

Technical Bulletins

Technical Articles

Product Manuals

Roadmap