Re: [Gdal-dev] SQLite problem

2008-10-30 Thread iomeneandrei
Hi all, I have change client and I have no more problems. Thank you for all. This is a great mailing list. Best regards, a P.S. the client is http://sqliteadmin.orbmu2k.de/ - Andrea Borruso email: [EMAIL PROTECTED] blog: http://blog.

Re: [Gdal-dev] SQLite problem

2008-10-29 Thread iomeneandrei
Hi Even, Even Rouault wrote: > > Yes, see http://www.sqlite.org/lang_altertable.html > You need SQLite > 3.1.3 > to build my sqlite spatial db I use ogr2ogr utility I have in the lates fwtools for windows. The same for ogrinfo. Whit this I have: "FAILURE: Unable to open datasource `C:\output2.s

Re: [Gdal-dev] SQLite problem

2008-10-29 Thread Even Rouault
Yes, see http://www.sqlite.org/lang_altertable.html You need SQLite > 3.1.3 Le Wednesday 29 October 2008 23:44:37 Even Rouault, vous avez écrit : > I can read output2.sqlite with ogrinfo: > > INFO: Open of `output2.sqlite' > using driver `SQLite' successful. > > Layer name: output > Geometry

Re: [Gdal-dev] SQLite problem

2008-10-29 Thread Even Rouault
I can read output2.sqlite with ogrinfo: INFO: Open of `output2.sqlite' using driver `SQLite' successful. Layer name: output Geometry: Point Feature Count: 2 Extent: (13.00, 38.00) - (13.50, 39.00) Layer SRS WKT: GEOGCS["WGS 84", DATUM["WGS_1984", SPHEROID["WGS 84

Re: [Gdal-dev] SQLite problem

2008-10-29 Thread iomeneandrei
Hi Even, thank you very much. Even Rouault wrote: > > This must be a problem with your SQLite client. > I will make some test with another client. Best regards, Andrea - Andrea Borruso email: [EMAIL PROTECTED] blog: http://blog.spaz

Re: [Gdal-dev] SQLite problem

2008-10-29 Thread iomeneandrei
Hi Frank, thank you very much. Frank Warmerdam-2 wrote: > > The file you referenced seems to work fine with my (trunk) ogrinfo. Can > you > provide an example that ogrinfo can't read? Generally, adding new columns > to > a spatial table should not cause problems for OGR. > The file I have att

Re: [Gdal-dev] SQLite problem

2008-10-29 Thread Frank Warmerdam
iomeneandrei wrote: Hi all, I have created a sqlite spatial db with ogr2ogr, starting from a simple shapefile. I'm able to read the proper info of this sqlite db with ogrinfo. If I add a column to this sqlite db inside the table where I have the WKT_GEOMETRY, ogrinfo is no more able to read pro

Re: [Gdal-dev] SQLite problem

2008-10-29 Thread Even Rouault
This must be a problem with your SQLite client. I used the sqlite3 console gui and did on your database: ALTER TABLE output ADD COLUMN newcolumn VARCHAR; ogrinfo was still working afterwards. Le Wednesday 29 October 2008 19:52:41 iomeneandrei, vous avez écrit : > d a column to this sqlite db ins

[Gdal-dev] SQLite problem

2008-10-29 Thread iomeneandrei
Hi all, I have created a sqlite spatial db with ogr2ogr, starting from a simple shapefile. I'm able to read the proper info of this sqlite db with ogrinfo. If I add a column to this sqlite db inside the table where I have the WKT_GEOMETRY, ogrinfo is no more able to read properly this db. Is it