Name: CoordinateSystem
Description: Format for Tooltip for CoordinateSystems
Type: SQL
Is Recursive: No
Conditional Formatting: No
Design Time Prog ID: SP3DLabelFormatDesigner.RTFLabel
Run Time Prog ID: SP3DLabelsFormat.FormatLabel
Returned Properties: Z
Y
X
SQL Query:
select
jname1.ItemName As 'Name',
jcoor.o0 As 'X',
jcoor.o1 As 'Y',
jcoor.o2 As 'Z',
jcoorp.Description As 'Desc'
from JDCoordinateSystem jcoor
Join JNamedItem jname1 on (jname1.oid = jcoor.oid)
Join SPGCoordinateSystemProperties jcoorp on (jcoorp.oid = jcoor.oid)
WHERE jcoor.oid = ?