Bug report #12461: Unable to commit date changes to MSSQL table in 2.8.1 Wien - QGIS Application - QGIS Issue Tracking

Bug report #12461

Unable to commit date changes to MSSQL table in 2.8.1 Wien

Added by Michael Hakkennes over 9 years ago. Updated over 9 years ago.

Status:	Closed
Priority:	Severe/Regression
Assignee:	-
Category:	Data Provider/MSSQL
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

Description

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.

Associated revisions

Revision 018cdd25
Added by Jürgen Fischer over 9 years ago

mssql provider: improve datetime support (fixes #12461)

Revision 447825bd
Added by Jürgen Fischer over 9 years ago

mssql provider: improve datetime support (fixes #12461)

(cherry-picked from 018cdd25)

History

#1 Updated by Giovanni Manghi over 9 years ago

Status changed from Open to Feedback

is the date entered manually or with an edit widget? it makes any difference using the widget or not?

#2 Updated by Michael Hakkennes over 9 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.

#3 Updated by Giovanni Manghi over 9 years ago

Priority changed from Normal to Severe/Regression

don't know much about date in ms sql server, anyway I'll tag this as a regression at least until someone that knows better qgis support for mssql can jump in.