User Tools

Site Tools


dynamiczip:install:mods:release:build71:sql_case_sensitive_sort_issues

Case Sensitive Sort Issues

SQL Server can be installed with a case sensitive sort (such as binary). When this is the case, more is affected than just the sort order. The primary issue that we have to deal with in our programming relates to the pass through SQL statements. The case sensitive sort also makes the SQL statements case sensitive. With the case sensitive sort, Dynamics and DYNAMICS are not equal.

DynamicZip Build 71.2 and Build 70.3 correct a problem in the pass through SQL used to generate the DynamicZip Tax Reports. This problem would result in the following error for case sensitive sorts:

Error executing SQL
GPS Error: 58 SQL Error: 4041 [Microsoft][SQL Native Client][SQL Server]
The multi-part identifier “TXDoc.DOCNUMBR” could not be bound.
ODBC Error: 37000


Build 70.3
Build 71.2
Modifications

dynamiczip/install/mods/release/build71/sql_case_sensitive_sort_issues.txt · Last modified: 2017/09/19 17:06 by conni

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki