DM Release Version 9.2.1
Release date: 26th February 2021
Usability Improvements
The following usability enhancements have now been implemented:
Escaping in the SQL searches - The code has changed to create columns in the database using the exact same name as the key, without changing hyphens to underscores. It achieves this by making sure the column name is escaped during creation, and during queries. Previously (9.2.0), the system would run SQL like this:
SELECT key_name FROM tblDocuments WHERE key_name = 'value'
When key_name included invalid characters or matched SQL keywords, the system would fail (as shown in the original bug report). Key names are now escaped like so:
SELECT [key-name] FROM tblDocuments WHERE [key-name] = 'value'
This is dependent on the database vendor. For more information, contact Formpipe Support.
Fixes
The following list contains details of fixes we have implemented since the last release:
Key names are now properly escaped to prevent clashes with the database during column creation.
The Scanning Rules Editor compatibility issue with DM 9.2 has now been resolved.