Changes

Location point

569 bytes added, 16:01, 9 October 2014

Created page with "{{Warning | This page contains UPDATE and DELETE queries}} This query changes '''Location point''' to '''Reference point''' <pre> UPDATE geopoint SET geopoint.pointtypeenum_g..."

{{Warning | This page contains UPDATE and DELETE queries}}

This query changes '''Location point''' to '''Reference point'''
<pre>
UPDATE geopoint
SET
geopoint.pointtypeenum_guid = '{BaseData-PointType-00000000000-00001}'
WHERE
geopoint.pointtypeenum_guid = '{TestData-PointType-00000000000-00009}'
</pre>

<pre>
DELETE FROM imsmaenum
WHERE
imsmaenum.enumcategory = 'Point Type' AND
imsmaenum.enumvalue = 'Location Point' AND
imsmaenum.imsmaenum_guid = '{TestData-PointType-00000000000-00009}'
</pre>

[[Category:NoPublic]]
[[Category:SQL Queries]]
[[Category:NAA]]

• Newer edit →

Alnaucler

NoPublic, bureaucrat, administrator

6,632

edits