Examples

A view which shows only locations on layer ABZWEIGER with state “Betrieb”

 

Select:

select geo.mi_prinx as MI_PRINX, geo.geoloc as GEOLOC, geo.mi_style as MI_STYLE, geo.cmexkey as CMEXKEY, geo.cmclassid as CMCLASSID, geo.cmobjectid as CMOBJECTID, 

t7.text as CmName,

t7.description as CmDescription

from ABZWEIGER_ geo 

left join des_designation t7 on t7.designation_id = geo.CmObjectId

left join vw_statedisplay t8 on t8.classid = 3 and t8.objectid = geo.cmobjectid

 

Where:

t8.displaytext = 'Betrieb'

 

A view with graphical override for state type “Betrieb”

 

Select:

select geo.mi_prinx as MI_PRINX, 

geo.geoloc as GEOLOC, 

'Symbol (35,'||

case cast (t8.displaytext as varchar(20))

when 'Betrieb' then '16744448'

else '0' end

||',12,"MapInfo Symbols",0,0)' as MI_STYLE, 

geo.cmexkey as CMEXKEY, geo.cmclassid as CMCLASSID, geo.cmobjectid as CMOBJECTID, 

t7.text as CmName,

t7.description as CmDescription

from ABZWEIGER_ geo 

left join des_designation t7 on t7.designation_id = geo.CmObjectId

left join vw_statedisplay t8 on t8.classid = 3 and t8.objectid = geo.cmobjectid