DM Release Version 9.2.1
Release date: 26th February 2021
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'
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.
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.