Hello Even Yes you are right, it works perfectly Thanks a lot
Ludovic Le 28/11/2010 17:23, Even Rouault a écrit :
Le lundi 22 novembre 2010 10:26:26, Ludovic Granjon a écrit :Hi all I try in a python script to delete a sqlite database that I use in an OGR ExecuteSQL. Let me give you an example : If I do : >>> from osgeo import * >>> import os >>> datasource = ogr.Open("decoupe.shp") >>> layer = datasource.GetLayer() >>> joinLayer=datasource.ExecuteSQL("SELECT decoupe.FID as ligne_id, c.lFid as ligne_id2, c.count as count FROM decoupe LEFT JOIN 'project.sqlite'.comptage c ON decoupe.FID=c.lFid")You probably need a datasource.ReleaseResultSet(joinLayer) at that point>>> datasource.Destroy() It seems that there still a connection to my sqlite database and I can't delete it. When I try on MS Windows (There's no error on linux) : >>> os.remove('project.sqlite') I have : Traceback (most recent call last): File "<pyshell#5>", line 1, in<module> os.remove('project.sqlite') WindowsError: [Error 13] Le processus ne peut pas accéder au fichier car ce fichier est utilisé par un autre processus: 'project.sqlite' Do you know a way to do that ? Thanks Best regards Ludovic
<<attachment: ludovic_granjon.vcf>>
_______________________________________________ gdal-dev mailing list gdal-dev@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/gdal-dev
