Skip to main content

Autoform DM 9.2.1 - News / Autoform DM / Autoform DM Release Notes - Formpipe Support Portal

Feb 26 2021

Autoform DM 9.2.1

Authors list

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.



Helpful Unhelpful

1 of 2 people found this page helpful

Add a comment

Please log in or register to submit a comment.

Need a password reminder?