View Incident Report

Minor

Reported By: John Csoglei
Reported On: 1/9/2012
For: Version 2.07 Build 1

# 3535 ODBC Driver Not Working Properly with ODBC Join Escape Sequences

We are using crystal report 8.5 with Delphi 7 and have trouble with a report

Using the tracing option of the "ODBC Datasource administrator" I discover that crystal

is generating a special syntax for join wich cause problems.

The following is the trace.

AlphaNP         a4c-ac8     ENTER SQLExecDirect 
                               HSTMT               0D4C2970
                               UCHAR *             0x0694B380 [      -3] "SELECT T12010."ACCOUNT_NR", T12010."ACC_TITLE", T12010."DESC1", T12010."DESC2", T12010."DESC3", T12010."GROUP_CODE", TmpTotCpt."TOT_D", TmpTotCpt."TOT_C" FROM { oj "A-T12010-010101_ST26_0" T12010 INNER JOIN "A-TOTTMP-010101_ST26_0" TmpTotCpt ON T12010."ACCOUNT_NR" = TmpTotCpt."ACCOUNT_NR"}\ 0"
                               SDWORD                    -3

AlphaNP         a4c-ac8     EXIT  SQLExecDirect  with return code -1 (SQL_ERROR)
                               HSTMT               0D4C2970
                               UCHAR *             0x0694B380 [      -3] "SELECT T12010."ACCOUNT_NR", T12010."ACC_TITLE", T12010."DESC1", T12010."DESC2", T12010."DESC3", T12010."GROUP_CODE", TmpTotCpt."TOT_D", TmpTotCpt."TOT_C" FROM { oj "A-T12010-010101_ST26_0" T12010 INNER JOIN "A-TOTTMP-010101_ST26_0" TmpTotCpt ON T12010."ACCOUNT_NR" = TmpTotCpt."ACCOUNT_NR"}\ 0"
                               SDWORD                    -3

                               DIAG [42000] [Elevate Software][ElevateDB] ElevateDB Error #700 An error was found in the statement at line 1 and column 189 (Expected end of expression but instead found T12010) (700)

Comments and Workarounds

There was a bug in the parsing of the escape sequences for the ODBC driver. The problem is the space before the "oj" portion of the escape sequence, so manually removing it will work as a workaround.

Resolution

Fixed Problem on 1/10/2012 in version 2.08 build 1

Products Affected

ElevateDB DAC Client-Server
ElevateDB DAC Client-Server with Source
ElevateDB DAC Standard
ElevateDB DAC Standard with Source
ElevateDB DAC Trial

More Support Options

Search Incident Reports

Support Forums

Frequently Asked Questions

Technical Bulletins

Technical Articles

Product Manuals

Roadmap