<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=Content-Type content="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 12 (filtered medium)">
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:"Trebuchet MS";
panose-1:2 11 6 3 2 2 2 2 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p
{mso-style-priority:99;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
span.EmailStyle18
{mso-style-type:personal;
font-family:"Arial","sans-serif";
color:windowtext;}
span.style21
{mso-style-name:style21;
font-family:"Trebuchet MS","sans-serif";
color:#0C3181;
font-weight:bold;}
span.style61
{mso-style-name:style61;
font-family:"Trebuchet MS","sans-serif";}
span.EmailStyle21
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page Section1
{size:612.0pt 792.0pt;
margin:72.0pt 90.0pt 72.0pt 90.0pt;}
div.Section1
{page:Section1;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang=EN-US link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>Hi,<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>I have looked into this and I got same behavior.<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>What is happing is that MG layer created from class doesn’t
have identity properties set.<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>If you select one feature it will be selected (just one in
properties window) but all will be rendered as selected (blue).<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>This means that provider is correctly running spatial filter to
select just one feature.<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>What I found in MapGuide is that if provider is returning just
one FDO Schema (KingOra ) instead of two FDO Schemas (KingOra and</span><span
style='font-size:10.0pt;font-family:"Courier New";color:maroon'> KingFdoClass </span><span
style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>) it
is working properly.<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>I have checked with Fdo2Fdo and both FDO classes, from base
table and view, look’s exactly same except FDO schema name and still layer
created in MapGuide for one class has identity property set and not for another
class.<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>I am not 100% sure but because of this findings in this moment it
looks like issue with MapGuide (or Studio) not the provider.<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>Unfortunately I am traveling again and right now I don’t’
have time to investigate it further.<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>My reply is coming little late because I was travelling and not
able to look at this before.<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>Haris<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<div>
<div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm'>
<p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span
style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'> mapguide-users-bounces@lists.osgeo.org
[mailto:mapguide-users-bounces@lists.osgeo.org] <b>On Behalf Of </b>Joseph
Doherty<br>
<b>Sent:</b> 17. april 2007 22:23<br>
<b>To:</b> mapguide-users@lists.osgeo.org<br>
<b>Subject:</b> [mapguide-users] King Oracle FDO Provider Single select hights
allfeatures<o:p></o:p></span></p>
</div>
</div>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'>I
am using Mapguide Enterprise 2007 SP1, Mapguide Studio, Oracle Enterprise Ed.
10.2.0.1.0 and the King Oracle FDO (0.6.4).<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'>Oracle
and Mapguide are on the same machine and using the regular Oracle Client, not
the Instant client.<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'>In
Mapguide Studio, I have a layer defined using a KingFDOClass based on a view.
When I view this layer in a Mapdefinition and select a single line, all the
lines are selected.<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'>This
behavior happens after applying SP1 to Mapguide. This behavior does not happen
when I use the base table.<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'>The
view has a primary key defined, below is additional info:<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt'>Below is the table
“CMGENCLD” , the King FDO Class definition table (showing
only the columns with values)<o:p></o:p></span></p>
<table class=MsoNormalTable border=1 cellpadding=0 align=left style='margin-left:
6.75pt;margin-right:6.75pt'>
<tr>
<td width=69 style='width:51.75pt;background:#CCCC99;padding:1.5pt 1.5pt 1.5pt 1.5pt'>
<p class=MsoNormal style='mso-element:frame;mso-element-frame-hspace:9.0pt;
mso-element-wrap:around;mso-element-anchor-vertical:paragraph;mso-element-anchor-horizontal:
column;mso-height-rule:exactly'><b><span style='font-size:8.0pt;color:#336699'>FDO_UNIQUE_ID</span></b><b><span
style='font-size:8.0pt'><o:p></o:p></span></b></p>
</td>
<td width=69 style='width:51.95pt;background:#CCCC99;padding:1.5pt 1.5pt 1.5pt 1.5pt'>
<p class=MsoNormal style='mso-element:frame;mso-element-frame-hspace:9.0pt;
mso-element-wrap:around;mso-element-anchor-vertical:paragraph;mso-element-anchor-horizontal:
column;mso-height-rule:exactly'><b><span style='font-size:8.0pt;font-family:
"Arial","sans-serif";color:#336699'>FDO</span></b><b><span style='font-size:
8.0pt;color:#336699'>_ORA_OWNER</span></b><b><span style='font-size:8.0pt'><o:p></o:p></span></b></p>
</td>
<td width=106 style='width:79.2pt;background:#CCCC99;padding:1.5pt 1.5pt 1.5pt 1.5pt'>
<p class=MsoNormal style='mso-element:frame;mso-element-frame-hspace:9.0pt;
mso-element-wrap:around;mso-element-anchor-vertical:paragraph;mso-element-anchor-horizontal:
column;mso-height-rule:exactly'><b><span style='font-size:8.0pt;color:#336699'>FDO_ORA_NAME</span></b><b><span
style='font-size:8.0pt'><o:p></o:p></span></b></p>
</td>
<td width=71 style='width:53.45pt;background:#CCCC99;padding:1.5pt 1.5pt 1.5pt 1.5pt'>
<p class=MsoNormal style='mso-element:frame;mso-element-frame-hspace:9.0pt;
mso-element-wrap:around;mso-element-anchor-vertical:paragraph;mso-element-anchor-horizontal:
column;mso-height-rule:exactly'><b><span style='font-size:8.0pt;color:#336699'>FDO_ORA_GEOMCOLUMN</span></b><b><span
style='font-size:8.0pt'><o:p></o:p></span></b></p>
</td>
<td width=116 style='width:87.0pt;background:#CCCC99;padding:1.5pt 1.5pt 1.5pt 1.5pt'>
<p class=MsoNormal style='mso-element:frame;mso-element-frame-hspace:9.0pt;
mso-element-wrap:around;mso-element-anchor-vertical:paragraph;mso-element-anchor-horizontal:
column;mso-height-rule:exactly'><b><span style='font-size:8.0pt;color:#336699'>FDO_SPATIALTABLE_OWNER</span></b><b><span
style='font-size:8.0pt'><o:p></o:p></span></b></p>
</td>
<td width=95 style='width:71.2pt;background:#CCCC99;padding:1.5pt 1.5pt 1.5pt 1.5pt'>
<p class=MsoNormal style='mso-element:frame;mso-element-frame-hspace:9.0pt;
mso-element-wrap:around;mso-element-anchor-vertical:paragraph;mso-element-anchor-horizontal:
column;mso-height-rule:exactly'><b><span style='font-size:8.0pt;color:#336699'>FDO_SPATIALTABLE_NAME</span></b><b><span
style='font-size:8.0pt'><o:p></o:p></span></b></p>
</td>
<td width=71 style='width:53.2pt;background:#CCCC99;padding:1.5pt 1.5pt 1.5pt 1.5pt'>
<p class=MsoNormal style='mso-element:frame;mso-element-frame-hspace:9.0pt;
mso-element-wrap:around;mso-element-anchor-vertical:paragraph;mso-element-anchor-horizontal:
column;mso-height-rule:exactly'><b><span style='font-size:8.0pt;color:#336699'>FDO_SPATIALTABLE_GEOMCOLUMN</span></b><b><span
style='font-size:8.0pt'><o:p></o:p></span></b></p>
</td>
<td width=130 style='width:97.85pt;background:#CCCC99;padding:1.5pt 1.5pt 1.5pt 1.5pt'>
<p class=MsoNormal style='mso-element:frame;mso-element-frame-hspace:9.0pt;
mso-element-wrap:around;mso-element-anchor-vertical:paragraph;mso-element-anchor-horizontal:
column;mso-height-rule:exactly'><b><span style='font-size:8.0pt;color:#336699'>FDO_CLASS_NAME</span></b><b><span
style='font-size:8.0pt'><o:p></o:p></span></b></p>
</td>
<td width=91 style='width:68.45pt;background:#CCCC99;padding:1.5pt 1.5pt 1.5pt 1.5pt'>
<p class=MsoNormal style='mso-element:frame;mso-element-frame-hspace:9.0pt;
mso-element-wrap:around;mso-element-anchor-vertical:paragraph;mso-element-anchor-horizontal:
column;mso-height-rule:exactly'><b><span style='font-size:8.0pt;color:#336699'>FDO_IDENTITY</span></b><b><span
style='font-size:8.0pt'><o:p></o:p></span></b></p>
</td>
</tr>
<tr>
<td width=69 style='width:51.75pt;background:#F7F7E7;padding:1.5pt 1.5pt 1.5pt 1.5pt'>
<p class=MsoNormal style='mso-element:frame;mso-element-frame-hspace:9.0pt;
mso-element-wrap:around;mso-element-anchor-vertical:paragraph;mso-element-anchor-horizontal:
column;mso-height-rule:exactly'><span style='font-size:8.0pt'>1061<o:p></o:p></span></p>
</td>
<td width=69 style='width:51.95pt;background:#F7F7E7;padding:1.5pt 1.5pt 1.5pt 1.5pt'>
<p class=MsoNormal style='mso-element:frame;mso-element-frame-hspace:9.0pt;
mso-element-wrap:around;mso-element-anchor-vertical:paragraph;mso-element-anchor-horizontal:
column;mso-height-rule:exactly'><span style='font-size:8.0pt'>GUTAPP<o:p></o:p></span></p>
</td>
<td width=106 style='width:79.2pt;background:#F7F7E7;padding:1.5pt 1.5pt 1.5pt 1.5pt'>
<p class=MsoNormal style='mso-element:frame;mso-element-frame-hspace:9.0pt;
mso-element-wrap:around;mso-element-anchor-vertical:paragraph;mso-element-anchor-horizontal:
column;mso-height-rule:exactly'><span style='font-size:8.0pt'>V_UTWATPIP_BASE<o:p></o:p></span></p>
</td>
<td width=71 style='width:53.45pt;background:#F7F7E7;padding:1.5pt 1.5pt 1.5pt 1.5pt'>
<p class=MsoNormal style='mso-element:frame;mso-element-frame-hspace:9.0pt;
mso-element-wrap:around;mso-element-anchor-vertical:paragraph;mso-element-anchor-horizontal:
column;mso-height-rule:exactly'><span style='font-size:8.0pt'>GEOMETRY<o:p></o:p></span></p>
</td>
<td width=116 style='width:87.0pt;background:#F7F7E7;padding:1.5pt 1.5pt 1.5pt 1.5pt'>
<p class=MsoNormal style='mso-element:frame;mso-element-frame-hspace:9.0pt;
mso-element-wrap:around;mso-element-anchor-vertical:paragraph;mso-element-anchor-horizontal:
column;mso-height-rule:exactly'><span style='font-size:8.0pt'>GUTAPP<o:p></o:p></span></p>
</td>
<td width=95 style='width:71.2pt;background:#F7F7E7;padding:1.5pt 1.5pt 1.5pt 1.5pt'>
<p class=MsoNormal style='mso-element:frame;mso-element-frame-hspace:9.0pt;
mso-element-wrap:around;mso-element-anchor-vertical:paragraph;mso-element-anchor-horizontal:
column;mso-height-rule:exactly'><span style='font-size:8.0pt'>UTWATPIP<o:p></o:p></span></p>
</td>
<td width=71 style='width:53.2pt;background:#F7F7E7;padding:1.5pt 1.5pt 1.5pt 1.5pt'>
<p class=MsoNormal style='mso-element:frame;mso-element-frame-hspace:9.0pt;
mso-element-wrap:around;mso-element-anchor-vertical:paragraph;mso-element-anchor-horizontal:
column;mso-height-rule:exactly'><span style='font-size:8.0pt'>GEOMETRY<o:p></o:p></span></p>
</td>
<td width=130 style='width:97.85pt;background:#F7F7E7;padding:1.5pt 1.5pt 1.5pt 1.5pt'>
<p class=MsoNormal style='mso-element:frame;mso-element-frame-hspace:9.0pt;
mso-element-wrap:around;mso-element-anchor-vertical:paragraph;mso-element-anchor-horizontal:
column;mso-height-rule:exactly'><span style='font-size:8.0pt'>V_UTWATPIP_BASE_CLS<o:p></o:p></span></p>
</td>
<td width=91 style='width:68.45pt;background:#F7F7E7;padding:1.5pt 1.5pt 1.5pt 1.5pt'>
<p class=MsoNormal style='mso-element:frame;mso-element-frame-hspace:9.0pt;
mso-element-wrap:around;mso-element-anchor-vertical:paragraph;mso-element-anchor-horizontal:
column;mso-height-rule:exactly'><span style='font-size:8.0pt'>DATALINK<o:p></o:p></span></p>
</td>
</tr>
</table>
<p class=MsoNormal><span style='font-size:11.0pt'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt'>These are entries in the
MDSYS.SDO_GEOM_METADATA_TABLE for the GUTAPP user/schema<o:p></o:p></span></p>
<table class=MsoNormalTable border=1 cellpadding=0>
<tr>
<td style='background:#CCCC99;padding:1.5pt 1.5pt 1.5pt 1.5pt'>
<p class=MsoNormal align=center style='text-align:center'><b><span
style='font-size:10.0pt;color:#336699'>SDO_OWNER</span><o:p></o:p></b></p>
</td>
<td style='background:#CCCC99;padding:1.5pt 1.5pt 1.5pt 1.5pt'>
<p class=MsoNormal align=center style='text-align:center'><b><span
style='font-size:10.0pt;color:#336699'>SDO_TABLE_NAME</span><o:p></o:p></b></p>
</td>
<td style='background:#CCCC99;padding:1.5pt 1.5pt 1.5pt 1.5pt'>
<p class=MsoNormal align=center style='text-align:center'><b><span
style='font-size:10.0pt;color:#336699'>SDO_COLUMN_NAME</span><o:p></o:p></b></p>
</td>
<td style='background:#CCCC99;padding:1.5pt 1.5pt 1.5pt 1.5pt'>
<p class=MsoNormal align=center style='text-align:center'><b><span
style='font-size:10.0pt;color:#336699'>SDO_SRID</span><o:p></o:p></b></p>
</td>
</tr>
<tr>
<td style='background:#F7F7E7;padding:1.5pt 1.5pt 1.5pt 1.5pt'>
<p class=MsoNormal><span style='font-size:10.0pt'>GUTAPP</span><o:p></o:p></p>
</td>
<td style='background:#F7F7E7;padding:1.5pt 1.5pt 1.5pt 1.5pt'>
<p class=MsoNormal><span style='font-size:10.0pt'>UTWATPIP</span><o:p></o:p></p>
</td>
<td style='background:#F7F7E7;padding:1.5pt 1.5pt 1.5pt 1.5pt'>
<p class=MsoNormal><span style='font-size:10.0pt'>GEOMETRY</span><o:p></o:p></p>
</td>
<td style='background:#F7F7E7;padding:1.5pt 1.5pt 1.5pt 1.5pt'>
<p class=MsoNormal><span style='font-size:10.0pt'>41051</span><o:p></o:p></p>
</td>
</tr>
<tr>
<td style='background:#F7F7E7;padding:1.5pt 1.5pt 1.5pt 1.5pt'>
<p class=MsoNormal><span style='font-size:10.0pt'>GUTAPP</span><o:p></o:p></p>
</td>
<td style='background:#F7F7E7;padding:1.5pt 1.5pt 1.5pt 1.5pt'>
<p class=MsoNormal><span style='font-size:10.0pt'>V_UTWATPIP_BASE</span><o:p></o:p></p>
</td>
<td style='background:#F7F7E7;padding:1.5pt 1.5pt 1.5pt 1.5pt'>
<p class=MsoNormal><span style='font-size:10.0pt'>GEOMETRY</span><o:p></o:p></p>
</td>
<td style='background:#F7F7E7;padding:1.5pt 1.5pt 1.5pt 1.5pt'>
<p class=MsoNormal><span style='font-size:10.0pt'>41051</span><o:p></o:p></p>
</td>
</tr>
</table>
<p class=MsoNormal><span style='font-size:11.0pt'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt'>Any thoughts or insights
would be appreciated.</span><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'><o:p> </o:p></span></p>
<p style='margin:0cm;margin-bottom:.0001pt'><span class=style21><span
style='font-size:10.0pt;color:black'>Mahalo,</span></span><span
style='color:black'><o:p></o:p></span></p>
<p style='margin:0cm;margin-bottom:.0001pt'> <o:p></o:p></p>
<p style='margin:0cm;margin-bottom:.0001pt'><span class=style21><span
style='font-size:10.0pt'>Joseph Doherty </span></span><span style='font-size:
8.5pt'><br>
</span><span class=style61><span style='font-size:8.5pt'>Software Engineer</span></span><o:p></o:p></p>
<p style='margin:0cm;margin-bottom:.0001pt'><span class=style61><span
style='font-size:8.5pt'>Oracle Certified Professional</span></span><o:p></o:p></p>
<p><span class=style61><span style='font-size:8.5pt'>Microdesk, Inc. </span></span><span
style='font-size:8.5pt;font-family:"Trebuchet MS","sans-serif"'><br>
<span class=style61>P: 781-419-8105 </span><br>
<span class=style61>C: 781-820-1389 </span><br>
<span class=style61>F: 781-890-5275 </span><br>
<span class=style61><a href="http://www.microdesk.com">www.microdesk.com </a></span></span> <o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
</div>
</body>
</html>