Location point: Difference between revisions
Jump to navigation
Jump to search
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..." |
No edit summary |
||
| Line 5: | Line 5: | ||
UPDATE geopoint | UPDATE geopoint | ||
SET | SET | ||
pointtypeenum_guid = '{BaseData-PointType-00000000000-00001}' | |||
WHERE | WHERE | ||
pointtypeenum_guid = '{TestData-PointType-00000000000-00009}' | |||
</pre> | </pre> | ||
Revision as of 11:53, 20 October 2014
 |
This page contains UPDATE and DELETE queries |
This query changes Location point to Reference point
UPDATE geopoint
SET
pointtypeenum_guid = '{BaseData-PointType-00000000000-00001}'
WHERE
pointtypeenum_guid = '{TestData-PointType-00000000000-00009}'
DELETE FROM imsmaenum
WHERE
imsmaenum.enumcategory = 'Point Type' AND
imsmaenum.enumvalue = 'Location Point' AND
imsmaenum.imsmaenum_guid = '{TestData-PointType-00000000000-00009}'