It seems that write to sqlite with Ogr doesn't work. Requires Gdal upgrade ?
To reproduce :
CREATE TABLE test( name VARCHAR (254));
Dim connOgr As OgrDatasource = New OgrDatasource
success = connOgr.Open(Context.sqlite)
connOgr.ExecuteSQL("Insert into test (name) values ('olivier');", msg)
msg => In ExecuteSQL(): sqlite3_step(Insert into test (name) values ('olivier'):
SQL logic error or missing database
Added OgrDatasource.Open2 method with forUpdateParameter;
Flushing is added in OgrDatasource.CreateLayer (otherwise the new layer wasn't written to the disk in case of SQLite);
Changes are available since commit https://github.com/MapWindow/MapWinGIS/commit/637d0bf1f0c4b82c461362266a3410239c5f9aeb
Fine, it works, I tried CREATE table, INSERT, DROP table, everything ok.
Thanks for this nice work !