[Qgis-user] SQL to update table

[Mats Elfström]

Hi Chuck!
Another approach, which may be useful at other times, is to simply exclude
these rows from label rendering.
There may be times when you want to shut off certain labels without
actually changing the table.
This is done in the Rendering box of the labeler.
Unbox Show all labels... and then write an appropriate expression below.
In a PosGIS table, this expression was valid:
"fieldname" IS NOT NULL

HtH
Mats.E

2015-03-14 22:57 GMT+01:00 Chuck Young <wylie1066 at gmail.com>:

> I am trying to eliminate the text "NULL" from a table.  I have imported a
> set of Tiger road data and in some of the columns that I need to display
> the data itr has "NULL" in the field.  If it is Null I would really like
> that NOT to show up in the labeling on the map.
>
> I have tried some standard SQL update queries but they didn't work.
>
> I tried the following from the QSpatialite form that appears from within
> QGIS.
> Example:
> update "mc-roadsegs" Set "RFROMHN" = "" Where "RFROMHN" = "NULL";
>
> I also tried to construct a query from within the query builf=der at the
> top of the Attribute table in Edit mode.
>
> I really need to remove these unwanted valued.  It has been a while since
> I used SQL on a routine basis so I am a bit rusty.
>
> Any help will be much appreciated!
>
> Thanks
>
> Chuck
>
> _______________________________________________
> Qgis-user mailing list
> Qgis-user at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/qgis-user
>



-- 
______________________________________________
Mats Elfström, Väpplingvägen 21, SE-227 38 LUND, Sweden
tel: +46 46 145959 / mob: +46 70 595 39 35
alt e-mail: mats.elfstrom at giskraft.com <mats.elfstrom at telia.com>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20150315/47a66350/attachment.html>