Hot answers tagged spatialite
give the qspatialite plugin a try (https://plugins.qgis.org/plugins/QspatiaLite/) (Create empty db, now you can select all your layers and add at one go. see screenshot 1)
This reminds the old quiz: 5 person will shake hands with each other. How many handshakes will there be in total? Is it 20 because everybody must shake hands with 4 other person? No, because if Mike shakes hands with John, John does not need to shake hands with Mike for another time. Let's assume that you have 5 points. Point number 1 does not shake hands ...
You are running against SQLite version 3.7.17, but Common Table Expressions (WITH clause) were not supported until 3.8.3. See change log here: http://www.sqlite.org/changes.html Unless you are trying to do a recursive query, you can either write your WITH clause as a view or use a subquery.
What you need is a general GDAL config option "SQLITE_LIST_ALL_TABLES" You can test what effect it has by comparing these two commands: ogrinfo db.sqlite ogrinfo db.sqlite --config SQLITE_LIST_ALL_TABLES yes The "list all tables" option is listing also such metadata tables which you for sure do not want to export and therefore it is better to explicitly ...
You need to edit the properties of yours fields Date and Time in QGIS. Go to the properties of your layer. Select the Fields tab. In the line of your field (date and time), click on Line edit. Select Date/Time. And then you can specify the format of your date or time -> it must be the same as defined in Qt Designer! If the properties are the same in your ...
Only top voted, non community-wiki answers of a minimum length are eligible