<html><head><style>body{font-family:Helvetica,Arial;font-size:13px}</style></head><body style="word-wrap:break-word"><div id="bloop_customfont" style="font-family:Helvetica,Arial;font-size:13px;color:rgba(0,0,0,1.0);margin:0px;line-height:auto">Hi,</div><div id="bloop_customfont" style="font-family:Helvetica,Arial;font-size:13px;color:rgba(0,0,0,1.0);margin:0px;line-height:auto"><br></div><div id="bloop_customfont" style="font-family:Helvetica,Arial;font-size:13px;color:rgba(0,0,0,1.0);margin:0px;line-height:auto">will do.</div><div id="bloop_customfont" style="font-family:Helvetica,Arial;font-size:13px;color:rgba(0,0,0,1.0);margin:0px;line-height:auto"><br></div><div id="bloop_customfont" style="font-family:Helvetica,Arial;font-size:13px;color:rgba(0,0,0,1.0);margin:0px;line-height:auto">I run into another problem. The update statement for multiple geometry fails. </div><div id="bloop_customfont" style="font-family:Helvetica,Arial;font-size:13px;color:rgba(0,0,0,1.0);margin:0px;line-height:auto"><br></div><div id="bloop_customfont" style="font-family:Helvetica,Arial;font-size:13px;color:rgba(0,0,0,1.0);margin:0px;line-height:auto"><div id="bloop_customfont" style="margin:0px"><div id="bloop_customfont" style="margin:0px">ERROR 1: In SetFeature(): sqlite3_prepare(UPDATE 'timeseries' SET "data" = ?"GEOMETRY" = ?,"end" = ?,"start" = ?,"station_id" = ?,"timestep" = ?,"type" = ?,"s" = ? WHERE "ogc_fid" = 1):</div><div id="bloop_customfont" style="margin:0px"> near ""GEOMETRY"": syntax error</div><div><br></div></div></div><div id="bloop_customfont" style="font-family:Helvetica,Arial;font-size:13px;color:rgba(0,0,0,1.0);margin:0px;line-height:auto">Looks like a comma is missing. Looking at the code my guess is gdal/gdal/ogr/ogrsf_frmts/sqlite/ogrsqlitetablelayer.cpp line 2640 misses a </div><div id="bloop_customfont" style="font-family:Helvetica,Arial;font-size:13px;color:rgba(0,0,0,1.0);margin:0px;line-height:auto"><br></div><div id="bloop_customfont" style="font-family:Helvetica,Arial;font-size:13px;color:rgba(0,0,0,1.0);margin:0px;line-height:auto">if( bNeedComma )</div><div id="bloop_customfont" style="font-family:Helvetica,Arial;font-size:13px;color:rgba(0,0,0,1.0);margin:0px;line-height:auto"><div id="bloop_customfont" style="margin:0px"> osCommand += ",";</div></div><div id="bloop_customfont" style="font-family:Helvetica,Arial;font-size:13px;color:rgba(0,0,0,1.0);margin:0px;line-height:auto"><div id="bloop_customfont" style="margin:0px"><br></div></div> <div id="bloop_sign_1477310583528742144" class="bloop_sign"></div> <br><p class="airmail_on">On 24 October 2016 at 11:00:34 pm, jratike80 (<a href="mailto:jukka.rahkonen@maanmittauslaitos.fi">jukka.rahkonen@maanmittauslaitos.fi</a>) wrote:</p> <blockquote type="cite" class="clean_bq"><span><div><div></div><div>Hi,<br><br>It does smell like a bug. Could you repeat my test and take care to have the<br>additional BLOB field created after the geometry field? For me this<br>workaround seems to work and there is only one geometry left and "data"<br>field is reported as "binary" type.<br><br>FID Column = ogc_fid<br>Geometry Column = geometry<br>end: String (0.0)<br>start: String (0.0)<br>station_id: Integer (0.0)<br>timestep: Integer (0.0)<br>type: String (0.0)<br>data: Binary (0.0)<br><br><br><br>--<br>View this message in context: <a href="http://osgeo-org.1560.x6.nabble.com/gdal-dev-Wrongly-identified-SQLITE-BLOB-as-geomtry-tp5292220p5292293.html">http://osgeo-org.1560.x6.nabble.com/gdal-dev-Wrongly-identified-SQLITE-BLOB-as-geomtry-tp5292220p5292293.html</a><br>Sent from the GDAL - Dev mailing list archive at Nabble.com.<br>_______________________________________________<br>gdal-dev mailing list<br><a href="mailto:gdal-dev@lists.osgeo.org">gdal-dev@lists.osgeo.org</a><br><a href="http://lists.osgeo.org/mailman/listinfo/gdal-dev">http://lists.osgeo.org/mailman/listinfo/gdal-dev</a></div></div></span></blockquote></body></html>