https://issues.qgis.org/https://issues.qgis.org/favicon.ico2017-07-04T05:27:08ZQGIS Issue TrackingQGIS Application - Bug report #16785: Constraint prevent adding feature to spatialite layer with auto-increment pkey https://issues.qgis.org/issues/16785?journal_id=806352017-07-04T05:27:08ZDenis Rouzauddenis.rouzaud@gmail.com
<ul></ul><p><img src="https://issues.qgis.org/attachments/download/11133/Screenshot%20from%202017-07-04%2007-22-25.png" alt="" /></p> QGIS Application - Bug report #16785: Constraint prevent adding feature to spatialite layer with auto-increment pkey https://issues.qgis.org/issues/16785?journal_id=806572017-07-05T10:14:46ZDarek Bobak
<ul><li><strong>File</strong> <a href="/attachments/download/11137/1.PNG">1.PNG</a> added</li><li><strong>File</strong> <a href="/attachments/download/11136/2.PNG">2.PNG</a> added</li></ul><p>It is possible to add pkuid manualy (QGIS master on Windows 10). But, QGIS does not add it automatically, which is definitely undesirable behaviour</p> QGIS Application - Bug report #16785: Constraint prevent adding feature to spatialite layer with auto-increment pkey https://issues.qgis.org/issues/16785?journal_id=806582017-07-05T10:18:35ZDenis Rouzauddenis.rouzaud@gmail.com
<ul></ul><p>On my side, I can't validate the form, see the attached screenshot (apply is disabled).</p> QGIS Application - Bug report #16785: Constraint prevent adding feature to spatialite layer with auto-increment pkey https://issues.qgis.org/issues/16785?journal_id=806602017-07-05T10:37:29ZDarek Bobak
<ul><li><strong>File</strong> <a href="/attachments/download/11138/field_properties.png">field_properties.png</a> added</li></ul><p>Did you try to manually write something in the pkuid field? And check, if the field properties allow edition of the field (see attached image).<br />In the meantime, I've found the way to make QGIS automatically fill that field with increment value. You have to insert and expression:<br /><pre>
$id
</pre><br />in the "Default value" field in the properties of the field.</p>
<p><img src="https://issues.qgis.org/attachments/download/11138/field_properties.png" alt="" /></p> QGIS Application - Bug report #16785: Constraint prevent adding feature to spatialite layer with auto-increment pkey https://issues.qgis.org/issues/16785?journal_id=806612017-07-05T10:42:00ZDenis Rouzauddenis.rouzaud@gmail.com
<ul></ul><p>nope, but if it's the solution, it should be done automatically!</p> QGIS Application - Bug report #16785: Constraint prevent adding feature to spatialite layer with auto-increment pkey https://issues.qgis.org/issues/16785?journal_id=806622017-07-05T10:42:38ZDarek Bobak
<ul></ul><p>I agree.</p> QGIS Application - Bug report #16785: Constraint prevent adding feature to spatialite layer with auto-increment pkey https://issues.qgis.org/issues/16785?journal_id=806632017-07-05T11:15:08ZGiovanni Manghigiovanni.manghi@gmail.com
<ul><li><strong>Status</strong> changed from <i>Open</i> to <i>Feedback</i></li></ul><p>does this affect only master/qgis3, correct?</p> QGIS Application - Bug report #16785: Constraint prevent adding feature to spatialite layer with auto-increment pkey https://issues.qgis.org/issues/16785?journal_id=806762017-07-05T13:06:42ZDenis Rouzauddenis.rouzaud@gmail.com
<ul></ul><p>Yes Master. <br />But why feedback? For me it's a serious blocker.</p> QGIS Application - Bug report #16785: Constraint prevent adding feature to spatialite layer with auto-increment pkey https://issues.qgis.org/issues/16785?journal_id=806792017-07-05T14:20:50ZGiovanni Manghigiovanni.manghi@gmail.com
<ul><li><strong>Status</strong> changed from <i>Feedback</i> to <i>Open</i></li></ul><p>Denis Rouzaud wrote:</p>
<blockquote>
<p>Yes Master. <br />But why feedback? For me it's a serious blocker.</p>
</blockquote>
<p>the status does not indicates the seriousness: feedback just means that the ticket is open and a question awaiting an answer has been posted. Seriousness is give by the priority field, and by the "regression" field.</p> QGIS Application - Bug report #16785: Constraint prevent adding feature to spatialite layer with auto-increment pkey https://issues.qgis.org/issues/16785?journal_id=855242017-12-29T19:03:04ZDenis Rouzauddenis.rouzaud@gmail.com
<ul><li><strong>Status</strong> changed from <i>Open</i> to <i>Closed</i></li></ul><p>fixed in 73674e8157925df6979485cf36804c6e252d03a1</p> QGIS Application - Bug report #16785: Constraint prevent adding feature to spatialite layer with auto-increment pkey https://issues.qgis.org/issues/16785?journal_id=871332018-02-22T10:21:17ZGiovanni Manghigiovanni.manghi@gmail.com
<ul><li><strong>Resolution</strong> set to <i>fixed/implemented</i></li></ul>