Bug report #12461

Unable to commit date changes to MSSQL table in 2.8.1 Wien

Added by Michael Hakkennes about 5 years ago. Updated almost 5 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 almost 5 years ago

mssql provider: improve datetime support (fixes #12461)

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

mssql provider: improve datetime support (fixes #12461)

(cherry-picked from 018cdd25)

History

#1 Updated by Giovanni Manghi about 5 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 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.

#3 Updated by Giovanni Manghi about 5 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.

#4 Updated by Giovanni Manghi almost 5 years ago

  • Status changed from Feedback to Open

#5 Updated by Jürgen Fischer almost 5 years ago

  • Status changed from Open to Closed

Also available in: Atom PDF