<html><head></head><body><div class="ydpd3f3d47ayahoo-style-wrap" style="font-family: Helvetica Neue, Helvetica, Arial, sans-serif; font-size: 13px;"><div></div>
<div dir="ltr" data-setdir="false">I was mistaken the call fails the second time when the dialect is sqlite whether its issued in one thread or multiple. </div><div dir="ltr" data-setdir="false"><br></div><div dir="ltr" data-setdir="false">The call work OK when the dialect is the default OGRSQL even when both calls are made in one thread.</div><div dir="ltr" data-setdir="false"><br></div><div dir="ltr" data-setdir="false">So there must be something extra that should be done for dialect sqlite.</div><div><br></div>
</div><div id="ydp95044d8dyahoo_quoted_1668496088" class="ydp95044d8dyahoo_quoted">
<div style="font-family:'Helvetica Neue', Helvetica, Arial, sans-serif;font-size:13px;color:#26282a;">
<div>
On Sunday, September 27, 2020, 03:00:07 a.m. GMT+8, gdal-dev-request@lists.osgeo.org <gdal-dev-request@lists.osgeo.org> wrote:
</div>
<div><br></div>
<div><br></div>
<div><div dir="ltr">Send gdal-dev mailing list submissions to<br></div><div dir="ltr"> <a href="mailto:gdal-dev@lists.osgeo.org" rel="nofollow" target="_blank">gdal-dev@lists.osgeo.org</a><br></div><div dir="ltr"><br></div><div dir="ltr">To subscribe or unsubscribe via the World Wide Web, visit<br></div><div dir="ltr"> <a href="https://lists.osgeo.org/mailman/listinfo/gdal-dev" rel="nofollow" target="_blank">https://lists.osgeo.org/mailman/listinfo/gdal-dev</a><br></div><div dir="ltr">or, via email, send a message with subject or body 'help' to<br></div><div dir="ltr"> <a href="mailto:gdal-dev-request@lists.osgeo.org" rel="nofollow" target="_blank">gdal-dev-request@lists.osgeo.org</a><br></div><div dir="ltr"><br></div><div dir="ltr">You can reach the person managing the list at<br></div><div dir="ltr"> <a href="mailto:gdal-dev-owner@lists.osgeo.org" rel="nofollow" target="_blank">gdal-dev-owner@lists.osgeo.org</a><br></div><div dir="ltr"><br></div><div dir="ltr">When replying, please edit your Subject line so it is more specific<br></div><div dir="ltr">than "Re: Contents of gdal-dev digest..."<br></div><div dir="ltr"><br></div><div dir="ltr"><br></div><div dir="ltr">Today's Topics:<br></div><div dir="ltr"><br></div><div dir="ltr"> 1. Re: ogr2ogr fails on second call with sql select (Paul<br></div><div dir="ltr"> Higgins) (Paul Higgins)<br></div><div dir="ltr"><br></div><div dir="ltr"><br></div><div dir="ltr">----------------------------------------------------------------------<br></div><div dir="ltr"><br></div><div dir="ltr">Message: 1<br></div><div dir="ltr">Date: Sat, 26 Sep 2020 03:55:59 +0000 (UTC)<br></div><div dir="ltr">From: Paul Higgins <<a href="mailto:phigginsca@yahoo.com" rel="nofollow" target="_blank">phigginsca@yahoo.com</a>><br></div><div dir="ltr">To: "<a href="mailto:gdal-dev@lists.osgeo.org" rel="nofollow" target="_blank">gdal-dev@lists.osgeo.org</a>" <<a href="mailto:gdal-dev@lists.osgeo.org" rel="nofollow" target="_blank">gdal-dev@lists.osgeo.org</a>><br></div><div dir="ltr">Subject: Re: [gdal-dev] ogr2ogr fails on second call with sql select<br></div><div dir="ltr"> (Paul Higgins)<br></div><div dir="ltr">Message-ID: <<a href="mailto:317679387.989976.1601092559719@mail.yahoo.com" rel="nofollow" target="_blank">317679387.989976.1601092559719@mail.yahoo.com</a>><br></div><div dir="ltr">Content-Type: text/plain; charset="utf-8"<br></div><div dir="ltr"><br></div><div dir="ltr"> I found that the only way around this is to make each call, that has a SELECT in it, to my ogr2ogr function in a separate thread. If there are no SELECTs in the calls then I can make them all in one thread.<br></div><div dir="ltr"> <br></div><div dir="ltr"> <br></div><div dir="ltr">-------------- next part --------------<br></div><div dir="ltr">An HTML attachment was scrubbed...<br></div><div dir="ltr">URL: <<a href="http://lists.osgeo.org/pipermail/gdal-dev/attachments/20200926/fa549af6/attachment-0001.html" rel="nofollow" target="_blank">http://lists.osgeo.org/pipermail/gdal-dev/attachments/20200926/fa549af6/attachment-0001.html</a>><br></div><div dir="ltr"><br></div><div dir="ltr">------------------------------<br></div><div dir="ltr"><br></div><div dir="ltr">Subject: Digest Footer<br></div><div dir="ltr"><br></div><div dir="ltr">_______________________________________________<br></div><div dir="ltr">gdal-dev mailing list<br></div><div dir="ltr"><a href="mailto:gdal-dev@lists.osgeo.org" rel="nofollow" target="_blank">gdal-dev@lists.osgeo.org</a><br></div><div dir="ltr"><a href="https://lists.osgeo.org/mailman/listinfo/gdal-dev" rel="nofollow" target="_blank">https://lists.osgeo.org/mailman/listinfo/gdal-dev</a><br></div><div dir="ltr"><br></div><div dir="ltr">------------------------------<br></div><div dir="ltr"><br></div><div dir="ltr">End of gdal-dev Digest, Vol 196, Issue 39<br></div><div dir="ltr">*****************************************<br></div></div>
</div>
</div></body></html>