creation of a view runnable on spatialite and compliant with qgis:
CREATE VIEW ucs_2013 as
select
rowid as rowid,
ucs2007 as ucs2007,
geometry as geometry
from
ucs2013;
insert into
views_geometry_columns(view_name,view_geometry,view_rowid,f_table_name,f_geometry_column,read_only)
values('ucs_2013','geometry','rowid','_ucs2013','geometry',1);
IS IMPORTANT TO USE THE ALIAS OTHERWISE THE QGIS SPATIALITE PROVIDER COULD WORK BAD
ALSO IS IMPORTANT TO HAVE THE ROWID field available in the view.
Nessun commento:
Posta un commento