is there way to store default style in relative path in spatialite??it has layer styles table,and a column 'f_table_catalog'.and in this column pathes are absolute,In Qgis project options i set relative path. If i move .sqlite to another directory and load the data then qgis doesn't see default style. and this "hand-made" procedure to load styles for every layer is annoying.

  • I tried many variants, no luck with this. sqlite.org/c3ref/open.html – Piotr Sadowski Jun 23 '15 at 10:05
  • When I move the sqlite db, I just update the 'f_table_catalog' with an up-to date path with field calculator - it works at least. – Piotr Sadowski Jun 23 '15 at 10:12

I'm using Spatialite_GUI 2.0.0-devel. If you set the f_table_catalog to NULL in layer_styles, you can move the .sqlite to another directory and the default styles still apply in QGIS

Update - this works in QGIS 2.14, but not in 2.18

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.