Issues after 8.3.2
Posted: Wed 02 Jun 2021 14:21
Windows 10 64bit, Delphi 7 Build 8.1, Oracle DB 12c with table having "DATEFIELD" DATE.
From regional settings decimal separator is "," and short date format "d.m.yyyy".
UniDac 8.3.2 is working with update query ParamByName('DATEFIELD').AsDateTime := Now; but later UniDac versions 8.4.1, 8.4.2 and 8.4.3 not anymore. Workaround was to define connection SpecificOptions.Values['DateFormat'] := 'YYYY-MM-DD' and then use ParamByName('DATEFIELD').AsString := FormatDateTime('YYYY-MM-DD', Now); It looks that regional settings are messing query parameters after version 8.3.2.
Another issue is a big increase of final exe size after upgrading from 8.3.2. With 8.3.2 exe size is 16,9 MB, but with 8.4.1 size is 17,6 MB. According to change history, there are no new features implemented, mainly bug fixes and reason for change is unknown. New issues were also found with MySQL queries but no changes mentioned in the history log. After SolarWinds case major increase of exe size without a good reason might indicate problems, which needs special handling.
So, we are stuck with version 8.3.2 now and need to evaluate usage of UniDac deeply, which is not good at all. Very disappointed with the progress, specially undocumented changes.
From regional settings decimal separator is "," and short date format "d.m.yyyy".
UniDac 8.3.2 is working with update query ParamByName('DATEFIELD').AsDateTime := Now; but later UniDac versions 8.4.1, 8.4.2 and 8.4.3 not anymore. Workaround was to define connection SpecificOptions.Values['DateFormat'] := 'YYYY-MM-DD' and then use ParamByName('DATEFIELD').AsString := FormatDateTime('YYYY-MM-DD', Now); It looks that regional settings are messing query parameters after version 8.3.2.
Another issue is a big increase of final exe size after upgrading from 8.3.2. With 8.3.2 exe size is 16,9 MB, but with 8.4.1 size is 17,6 MB. According to change history, there are no new features implemented, mainly bug fixes and reason for change is unknown. New issues were also found with MySQL queries but no changes mentioned in the history log. After SolarWinds case major increase of exe size without a good reason might indicate problems, which needs special handling.
So, we are stuck with version 8.3.2 now and need to evaluate usage of UniDac deeply, which is not good at all. Very disappointed with the progress, specially undocumented changes.