<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 Even and Jukka,</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">Thanks for the quick fixes!</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">Just tested the code from the master and it works for my use case.</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">Cheers</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">Christian</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"><br></div> <br> <div id="bloop_sign_1477352902214216960" class="bloop_sign"></div> <br><p class="airmail_on">On 24 October 2016 at 11:33:17 pm, Even Rouault (<a href="mailto:even.rouault@spatialys.com">even.rouault@spatialys.com</a>) wrote:</p> <blockquote type="cite" class="clean_bq"><span><div><div></div><div>Le lundi 24 octobre 2016 14:10:34, Christian Urich a écrit :
<br>> Hi,
<br>>
<br>> will do.
<br>>
<br>> I run into another problem. The update statement for multiple geometry
<br>> fails.
<br>>
<br>> ERROR 1: In SetFeature(): sqlite3_prepare(UPDATE 'timeseries' SET "data" =
<br>> ?"GEOMETRY" = ?,"end" = ?,"start" = ?,"station_id" = ?,"timestep" =
<br>> ?,"type" = ?,"s" = ? WHERE "ogc_fid" = 1):
<br>> near ""GEOMETRY"": syntax error
<br>>
<br>> Looks like a comma is missing. Looking at the code my guess is
<br>> gdal/gdal/ogr/ogrsf_frmts/sqlite/ogrsqlitetablelayer.cpp line 2640 misses a
<br>>
<br>> if( bNeedComma )
<br>> osCommand += ",";
<br>>
<br>
<br>Good catch! Thanks. Fixed per <a href="https://trac.osgeo.org/gdal/ticket/6696">https://trac.osgeo.org/gdal/ticket/6696</a>
<br>
<br>--
<br>Spatialys - Geospatial professional services
<br><a href="http://www.spatialys.com">http://www.spatialys.com</a>
<br></div></div></span></blockquote></body></html>