Bug report #12461
Unable to commit date changes to MSSQL table in 2.8.1 Wien
|Affected QGIS version:||2.8.1||Regression?:||No|
|Operating System:||Easy fix?:||No|
|Pull Request or Patch supplied:||No||Resolution:|
|Crashes QGIS or corrupts data:||No||Copied to github as #:||20616|
Have entered a date as an attribute in "yyyy-mm-dd" format which is accepted in the feature attributes window but when saving layer edits back to MSSQL table the error message, "Could not commit changes to layer" appears.
I am able to save date edits to the same MSSQL table in version 2.6.1.
#2 Updated by Michael Hakkennes about 5 years ago
When a field is set to a "Text edit" edit widget a date is able to be typed in, but changes do not commit to MSSQL. In previous versions (2.6.1) it was possible to type in a date in a text edit widget and save changes.
When a field is set to a "Date/Time" edit widget a date is able to be selected and changes are able to be saved to MSSQL. However if null values are allowed, I am unable to start typing in a date, first a date must be selected and then typed to override the date.