New answers tagged sqlite
Try UNION ALL for collecting all the geometries before running ST_COLLECT. SELECT ST_Collect(geometry) FROM (SELECT geometry from tbl1 UNION ALL SELECT geometry from tbl2 UNION ALL SELECT geometry from tbl3 UNION ALL SELECT geometry from tbl4);
The problem is probably that you are keeping "Add saved file to map" as an option. However, wasn't the file actually saved in spite of the error? Testing this with a loaded non-spatial CSV file (wasn't sure how to get a DBF file loaded as per your example), and doing save-as with an SQLite but keeping "Add saved file to map" ticked, I get the same error. ...
Can't tell you why your export doesn't work in general, but can give you another way of exporting. Create the database first via new layer or browser and add the table using the DB-Manager. Use the options button to let the program set the needed options, then you don't have to care about the rest. The problem is that the save layer as-tool is not yet ...
Top 50 recent answers are included