Am 10.11.2015, 16:00 Uhr, schrieb kimaidou <[email protected]>:
Hi,
You could probably try the last "master" QGIS and processing, as
René-Luc (rldhont) added a couple of days ago the ability to save
>scripts and algs result layers into a spatialite database. Combined
with the tool "Refactor" ( visible in the Processing toolbox), >and
using your initial spatialite table, this could do the trick without the
need to create a new plugin for this.
Nice! Seems to work so far!
Now some people should be really really brave and make the sqlite entry
the first in the dropdown menu when saving to file and push ESRI shapefile
to the end ;)
Thanx for the hint
Bernd
Regards
Michaël
2015-11-10 15:42 GMT+01:00 Bernd Vogelgesang <[email protected]>:
Hi Micha,
yeah, working with spatialite dbs "seriously" is still quite
uncomfortable.
When I try, I mostly have to use all available means to get the work
done: DBManager, QSpatialite, SpatialiteGUI. Unfortunately >>I easily
forget how sql works, so doing "easy" stuff becomes very time consuming
and frustrating.
Do you think it would be technically possible to create a plugin like
Table Manager plugin, that records the changes you want to >>do to the
table and then creates the necessary sql commands and performs all that
stuff in one go?
Cause this would be sth I really would be interested donating money on!
Cheers
Bernd
Am 10.11.2015, 15:26 Uhr, schrieb Micha Silver <[email protected]>:
I have found that QGIS cannot "see" any spatialite column that comes
after the "geometry" column. When I alter a table, adding >>>a column
in a Spatialite, the new column which is after the geometry column in
the database table just does not appear in QGIS. >>>If I recreate the
table, reordering the columns so that the geometry is last, all is
good again.
Is this a bug? or am I missing something?
It's quite annoying considering that sqlite does not have any simple
way to shuffle the columns around, other than dropping and
>>>recreating the table. And if I have foreign constraints defined, it
becomes a whole row of dominoes that come down...
Thanks,
Micha
--Bernd Vogelgesang
Siedlerstraße 2
91083 Baiersdorf/Igelsdorf
Tel: 09133-825374
_______________________________________________
Qgis-user mailing list
[email protected]
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user
--
Bernd Vogelgesang
Siedlerstraße 2
91083 Baiersdorf/Igelsdorf
Tel: 09133-825374
_______________________________________________
Qgis-user mailing list
[email protected]
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user
