KampData Knowledge Base

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.

====== 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 [[dynamiczip:install:mods:release:build71:build71_sp2|Build 71.2]] and [[dynamiczip:install:mods:release:build70:build703|Build 70.3]] correct a problem in the pass through SQL used to generate the [[dynamiczip:reports: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


----

[[dynamiczip:install:mods:release:build70:build703|Build 70.3]] \\
[[dynamiczip:install:mods:release:build71:build71_sp2|Build 71.2]]\\
[[dynamiczip:install:mods:modifications|Modifications]]