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 almost 10 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 almost 10 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 almost 10 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.