Re: [gdal-dev] OGR ExecuteSQL

2020-01-23 Thread Mateusz Loskot
The new docs are searchable https://gdal.org/search.html?q=ExecuteSQL Mateusz Loskot, mate...@loskot.net (Sent from mobile, may suffer from top-posting) On Thu, 23 Jan 2020, 18:04 Andrew Bell, wrote: > > Thanks. Just located it in the documentation. Google was not my friend > in this case.

Re: [gdal-dev] OGR ExecuteSQL

2020-01-23 Thread Andrew Bell
Thanks. Just located it in the documentation. Google was not my friend in this case. Sorry to bother, On Thu, Jan 23, 2020 at 1:03 PM Even Rouault wrote: > On jeudi 23 janvier 2020 12:49:38 CET Andrew Bell wrote: > > Hi, > > > > This function returns a pointer to a layer. Does the dataset re

Re: [gdal-dev] OGR ExecuteSQL

2020-01-23 Thread Even Rouault
On jeudi 23 janvier 2020 12:49:38 CET Andrew Bell wrote: > Hi, > > This function returns a pointer to a layer. Does the dataset retain > ownership of the layer, or does the user need to make sure that the layer > gets deleted? > https://gdal.org/api/gdaldataset_cpp.html#_CPPv4N11GDALDataset10Ex

[gdal-dev] OGR ExecuteSQL

2020-01-23 Thread Andrew Bell
Hi, This function returns a pointer to a layer. Does the dataset retain ownership of the layer, or does the user need to make sure that the layer gets deleted? Thanks, -- Andrew Bell andrew.bell...@gmail.com ___ gdal-dev mailing list gdal-dev@lists.o

Re: [gdal-dev] Ogr: ExecuteSQL with MSSQL and geometry column

2012-07-23 Thread Benjamin
yer = RclDataSource.ExecuteSQL(request, null, ""); >>> >>> ** ** >>> >>> Driver memDriver = Ogr.GetDriverByName("Memory"); >>> >>> DataSource memDataSource = memDriver.CreateDataSource(GetWorkPath( >>> "nomimpr

Re: [gdal-dev] Ogr: ExecuteSQL with MSSQL and geometry column

2012-07-20 Thread Benjamin
; > serverLayer.GetLayerDefn().GetFieldCount(); //return 3 >>> > serverLayer.GetLayerDefn().GetFieldDefn(0).GetName(); //return "D" >>> > serverLayer.GetLayerDefn().GetFieldDefn(1).GetName(); //return >>> "CHART_ID" >>

Re: [gdal-dev] Ogr: ExecuteSQL with MSSQL and geometry column

2012-07-18 Thread Chaitanya kumar CH
0; i < memFeature.GetFieldCount(); i++) > > namesColumnsArray[i] = memFeature.GetFieldDefnRef(i).GetName(); > > Geometry memGeometry = memFeature.GetGeometryRef(); > > [/code] > > ** ** > > Results : > > namesColumnsArray = { D , CHART_ID, WKB_GEOM

Re: [gdal-dev] Ogr: ExecuteSQL with MSSQL and geometry column

2012-07-18 Thread Benjamin LUX
namesColumnsArray = { D , CHART_ID, WKB_GEOMETRY } memGeometry = null I don’t see what I can add to this :/ If you want more details said me. Link to the thread : http://osgeo-org.1560.n6.nabble.com/gdal-dev-Ogr-ExecuteSQL-with-MSSQL-and-geometry-column-tp4988831.

Re: [gdal-dev] Ogr: ExecuteSQL with MSSQL and geometry column

2012-07-18 Thread Chaitanya kumar CH
xt.Encoding.UTF8.GetBytes(memFeature.GetFieldAsString("WKB_GEOMETRY")); > > Geometry memGeom = Geometry.CreateFromWkb(memWkb); > > [/code] > > Because I can't use memFeature.GetGeometryRef() > > [code] > > memFeature.GetLayerCount();

Re: [gdal-dev] Ogr: ExecuteSQL with MSSQL and geometry column

2012-07-18 Thread Chaitanya kumar CH
n't know if I have to use UTF8, ASCII, Unicode or other. > If you know what encoding is use, or better an other trick to have a > geometry in my memLayer or serverLayer I heard you with interest ! > > > Sorry for my spelling, English isn't my native tongue language. > > Be

Re: [gdal-dev] Ogr: ExecuteSQL with MSSQL and geometry column

2012-07-18 Thread Benjamin
r an other trick to have a geometry in my memLayer or serverLayer I heard you with interest ! Sorry for my spelling, English isn't my native tongue language. Benjamin Ps : link to the thread: http://osgeo-org.1560.n6.nabble.com/gdal-dev-Ogr-ExecuteSQL-with-MSSQL-and-geometry-column-tp49

Re: [gdal-dev] Ogr: ExecuteSQL with MSSQL and geometry column

2012-07-18 Thread Even Rouault
Selon Benjamin : > "You can access the geometry like with any other ogr feature." > Hopefully, memFeature.GetGeometryRef() should do it ! ___ gdal-dev mailing list gdal-dev@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/gdal-dev

Re: [gdal-dev] Ogr: ExecuteSQL with MSSQL and geometry column

2012-07-18 Thread Benjamin
etry.CreateFromWkb(memWkb); [/code] It's UTF8, ASCII, Unicode ? -- View this message in context: http://osgeo-org.1560.n6.nabble.com/gdal-dev-Ogr-ExecuteSQL-with-MSSQL-and-geometry-column-tp4988831p4988966.html Sent from the GDAL - Dev mail

Re: [gdal-dev] Ogr: ExecuteSQL with MSSQL and geometry column

2012-07-17 Thread Chaitanya kumar CH
rverLayer ( or a layer provide by a Memory Driver) have any > method "ChoseGeometryField" or "SetGeometryColumn" (or I have missed it). > > > If I call serverDataSource.GetLayerByName("MY_TABLE").GetGeometryColumn() > it > work fine and result "

[gdal-dev] Ogr: ExecuteSQL with MSSQL and geometry column

2012-07-17 Thread Benjamin
quot;MY_TABLE").GetGeometryColumn() it work fine and result "WKB_GEOMETRY". Any suggests ? Regards, Benjamin. -- View this message in context: http://osgeo-org.1560.n6.nabble.com/gdal-dev-Ogr-ExecuteSQL-with-MSSQL-and-geometry-column-tp4988831.html Sent from the GDAL - Dev maili