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 dependant on the database vendor, see SQL Apps FAQ for more details.
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.
- Scanning Rules Editor compatibility issue with DM 9.2 is now resolved.
Add a comment
Please log in or register to submit a comment.