I converted a shapefile to a SpatiaLite database so I could work with attributes with a length longer than 254 characters, and also not see some columns and change their order.
In QGIS 2.18.16 I have used DB Manager to connect to this SQLite database, selecting the columns from the table I want to bring into my project, and in the order I want to work with the columns.
I am using the following code in the SQL window to do this
`SELECT id, cpt, sub_cpt, name, area_hect, category, designat, grid_ref, species, plant_year, activity, actvtynote, years, restock, notes, GEOMETRY From "clientname subcompartments SQLITE "
It loads into the project fine, but the layer is not editable? I have the SQLite file on my local hard drive
How to load it as an editable layer?
I am sure it must be something simple that I am not doing, or just basic misunderstanding as I am not familiar with working with SQLite.
I have had a look through GIS Stack Exchange but cannot find anything.