<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="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 11 (filtered medium)">
<style>
<!--
/* Font Definitions */
@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:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;}
p
{mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:12.0pt;
font-family:"Times New Roman";}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:Arial;
color:windowtext;}
span.style21
{font-family:"Trebuchet MS";
color:#0C3181;
font-weight:bold;}
span.style61
{font-family:"Trebuchet MS";}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;}
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><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>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></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Oracle and Mapguide are on the same machine and using the
regular Oracle Client, not the Instant client.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>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></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>This behavior happens after applying SP1 to Mapguide. This
behavior does not happen when I use the base table.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>The view has a primary key defined, below is additional
info:<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face="Times New Roman"><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></font></p>
<table class=MsoNormalTable border=1 cellpadding=0 align=left style='margin-left:
6.75pt;margin-right:6.75pt'>
<tr>
<td width=69 bgcolor="#CCCC99" style='width:51.75pt;background:#CCCC99;
padding:1.5pt 1.5pt 1.5pt 1.5pt'>
<p class=MsoNormal style='mso-element:frame'><b><font size=1 color="#336699"
face="Times New Roman"><span style='font-size:8.0pt;color:#336699;font-weight:
bold'>FDO_UNIQUE_ID</span></font></b><b><font size=1><span style='font-size:
8.0pt;font-weight:bold'><o:p></o:p></span></font></b></p>
</td>
<td width=69 bgcolor="#CCCC99" style='width:51.95pt;background:#CCCC99;
padding:1.5pt 1.5pt 1.5pt 1.5pt'>
<p class=MsoNormal style='mso-element:frame'><b><font size=1 color="#336699"
face=Arial><span style='font-size:8.0pt;font-family:Arial;color:#336699;
font-weight:bold'>FDO</span></font></b><b><font size=1 color="#336699"><span
style='font-size:8.0pt;color:#336699;font-weight:bold'>_ORA_OWNER</span></font></b><b><font
size=1><span style='font-size:8.0pt;font-weight:bold'><o:p></o:p></span></font></b></p>
</td>
<td width=106 bgcolor="#CCCC99" style='width:1.1in;background:#CCCC99;
padding:1.5pt 1.5pt 1.5pt 1.5pt'>
<p class=MsoNormal style='mso-element:frame'><b><font size=1 color="#336699"
face="Times New Roman"><span style='font-size:8.0pt;color:#336699;font-weight:
bold'>FDO_ORA_NAME</span></font></b><b><font size=1><span style='font-size:
8.0pt;font-weight:bold'><o:p></o:p></span></font></b></p>
</td>
<td width=71 bgcolor="#CCCC99" style='width:53.45pt;background:#CCCC99;
padding:1.5pt 1.5pt 1.5pt 1.5pt'>
<p class=MsoNormal style='mso-element:frame'><b><font size=1 color="#336699"
face="Times New Roman"><span style='font-size:8.0pt;color:#336699;font-weight:
bold'>FDO_ORA_GEOMCOLUMN</span></font></b><b><font size=1><span
style='font-size:8.0pt;font-weight:bold'><o:p></o:p></span></font></b></p>
</td>
<td width=116 bgcolor="#CCCC99" style='width:87.0pt;background:#CCCC99;
padding:1.5pt 1.5pt 1.5pt 1.5pt'>
<p class=MsoNormal style='mso-element:frame'><b><font size=1 color="#336699"
face="Times New Roman"><span style='font-size:8.0pt;color:#336699;font-weight:
bold'>FDO_SPATIALTABLE_OWNER</span></font></b><b><font size=1><span
style='font-size:8.0pt;font-weight:bold'><o:p></o:p></span></font></b></p>
</td>
<td width=95 bgcolor="#CCCC99" style='width:71.2pt;background:#CCCC99;
padding:1.5pt 1.5pt 1.5pt 1.5pt'>
<p class=MsoNormal style='mso-element:frame'><b><font size=1 color="#336699"
face="Times New Roman"><span style='font-size:8.0pt;color:#336699;font-weight:
bold'>FDO_SPATIALTABLE_NAME</span></font></b><b><font size=1><span
style='font-size:8.0pt;font-weight:bold'><o:p></o:p></span></font></b></p>
</td>
<td width=71 bgcolor="#CCCC99" style='width:53.2pt;background:#CCCC99;
padding:1.5pt 1.5pt 1.5pt 1.5pt'>
<p class=MsoNormal style='mso-element:frame'><b><font size=1 color="#336699"
face="Times New Roman"><span style='font-size:8.0pt;color:#336699;font-weight:
bold'>FDO_SPATIALTABLE_GEOMCOLUMN</span></font></b><b><font size=1><span
style='font-size:8.0pt;font-weight:bold'><o:p></o:p></span></font></b></p>
</td>
<td width=130 bgcolor="#CCCC99" style='width:97.85pt;background:#CCCC99;
padding:1.5pt 1.5pt 1.5pt 1.5pt'>
<p class=MsoNormal style='mso-element:frame'><b><font size=1 color="#336699"
face="Times New Roman"><span style='font-size:8.0pt;color:#336699;font-weight:
bold'>FDO_CLASS_NAME</span></font></b><b><font size=1><span style='font-size:
8.0pt;font-weight:bold'><o:p></o:p></span></font></b></p>
</td>
<td width=91 bgcolor="#CCCC99" style='width:68.45pt;background:#CCCC99;
padding:1.5pt 1.5pt 1.5pt 1.5pt'>
<p class=MsoNormal style='mso-element:frame'><b><font size=1 color="#336699"
face="Times New Roman"><span style='font-size:8.0pt;color:#336699;font-weight:
bold'>FDO_IDENTITY</span></font></b><b><font size=1><span style='font-size:
8.0pt;font-weight:bold'><o:p></o:p></span></font></b></p>
</td>
</tr>
<tr>
<td width=69 bgcolor="#F7F7E7" style='width:51.75pt;background:#F7F7E7;
padding:1.5pt 1.5pt 1.5pt 1.5pt'>
<p class=MsoNormal style='mso-element:frame'><font size=1
face="Times New Roman"><span style='font-size:8.0pt'>1061<o:p></o:p></span></font></p>
</td>
<td width=69 bgcolor="#F7F7E7" style='width:51.95pt;background:#F7F7E7;
padding:1.5pt 1.5pt 1.5pt 1.5pt'>
<p class=MsoNormal style='mso-element:frame'><font size=1
face="Times New Roman"><span style='font-size:8.0pt'>GUTAPP<o:p></o:p></span></font></p>
</td>
<td width=106 bgcolor="#F7F7E7" style='width:1.1in;background:#F7F7E7;
padding:1.5pt 1.5pt 1.5pt 1.5pt'>
<p class=MsoNormal style='mso-element:frame'><font size=1
face="Times New Roman"><span style='font-size:8.0pt'>V_UTWATPIP_BASE<o:p></o:p></span></font></p>
</td>
<td width=71 bgcolor="#F7F7E7" style='width:53.45pt;background:#F7F7E7;
padding:1.5pt 1.5pt 1.5pt 1.5pt'>
<p class=MsoNormal style='mso-element:frame'><font size=1
face="Times New Roman"><span style='font-size:8.0pt'>GEOMETRY<o:p></o:p></span></font></p>
</td>
<td width=116 bgcolor="#F7F7E7" style='width:87.0pt;background:#F7F7E7;
padding:1.5pt 1.5pt 1.5pt 1.5pt'>
<p class=MsoNormal style='mso-element:frame'><font size=1
face="Times New Roman"><span style='font-size:8.0pt'>GUTAPP<o:p></o:p></span></font></p>
</td>
<td width=95 bgcolor="#F7F7E7" style='width:71.2pt;background:#F7F7E7;
padding:1.5pt 1.5pt 1.5pt 1.5pt'>
<p class=MsoNormal style='mso-element:frame'><font size=1
face="Times New Roman"><span style='font-size:8.0pt'>UTWATPIP<o:p></o:p></span></font></p>
</td>
<td width=71 bgcolor="#F7F7E7" style='width:53.2pt;background:#F7F7E7;
padding:1.5pt 1.5pt 1.5pt 1.5pt'>
<p class=MsoNormal style='mso-element:frame'><font size=1
face="Times New Roman"><span style='font-size:8.0pt'>GEOMETRY<o:p></o:p></span></font></p>
</td>
<td width=130 bgcolor="#F7F7E7" style='width:97.85pt;background:#F7F7E7;
padding:1.5pt 1.5pt 1.5pt 1.5pt'>
<p class=MsoNormal style='mso-element:frame'><font size=1
face="Times New Roman"><span style='font-size:8.0pt'>V_UTWATPIP_BASE_CLS<o:p></o:p></span></font></p>
</td>
<td width=91 bgcolor="#F7F7E7" style='width:68.45pt;background:#F7F7E7;
padding:1.5pt 1.5pt 1.5pt 1.5pt'>
<p class=MsoNormal style='mso-element:frame'><font size=1
face="Times New Roman"><span style='font-size:8.0pt'>DATALINK<o:p></o:p></span></font></p>
</td>
</tr>
</table>
<p class=MsoNormal><font size=2 face="Times New Roman"><span style='font-size:
11.0pt'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face="Times New Roman"><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></font></p>
<table class=MsoNormalTable border=1 cellpadding=0>
<tr>
<td bgcolor="#CCCC99" style='background:#CCCC99;padding:1.5pt 1.5pt 1.5pt 1.5pt'>
<p class=MsoNormal align=center style='text-align:center'><b><font size=2
color="#336699" face="Times New Roman"><span style='font-size:10.0pt;
color:#336699;font-weight:bold'>SDO_OWNER</span></font><o:p></o:p></b></p>
</td>
<td bgcolor="#CCCC99" style='background:#CCCC99;padding:1.5pt 1.5pt 1.5pt 1.5pt'>
<p class=MsoNormal align=center style='text-align:center'><b><font size=2
color="#336699" face="Times New Roman"><span style='font-size:10.0pt;
color:#336699;font-weight:bold'>SDO_TABLE_NAME</span></font><o:p></o:p></b></p>
</td>
<td bgcolor="#CCCC99" style='background:#CCCC99;padding:1.5pt 1.5pt 1.5pt 1.5pt'>
<p class=MsoNormal align=center style='text-align:center'><b><font size=2
color="#336699" face="Times New Roman"><span style='font-size:10.0pt;
color:#336699;font-weight:bold'>SDO_COLUMN_NAME</span></font><o:p></o:p></b></p>
</td>
<td bgcolor="#CCCC99" style='background:#CCCC99;padding:1.5pt 1.5pt 1.5pt 1.5pt'>
<p class=MsoNormal align=center style='text-align:center'><b><font size=2
color="#336699" face="Times New Roman"><span style='font-size:10.0pt;
color:#336699;font-weight:bold'>SDO_SRID</span></font><o:p></o:p></b></p>
</td>
</tr>
<tr>
<td bgcolor="#F7F7E7" style='background:#F7F7E7;padding:1.5pt 1.5pt 1.5pt 1.5pt'>
<p class=MsoNormal><font size=2 face="Times New Roman"><span
style='font-size:10.0pt'>GUTAPP</span></font><o:p></o:p></p>
</td>
<td bgcolor="#F7F7E7" style='background:#F7F7E7;padding:1.5pt 1.5pt 1.5pt 1.5pt'>
<p class=MsoNormal><font size=2 face="Times New Roman"><span
style='font-size:10.0pt'>UTWATPIP</span></font><o:p></o:p></p>
</td>
<td bgcolor="#F7F7E7" style='background:#F7F7E7;padding:1.5pt 1.5pt 1.5pt 1.5pt'>
<p class=MsoNormal><font size=2 face="Times New Roman"><span
style='font-size:10.0pt'>GEOMETRY</span></font><o:p></o:p></p>
</td>
<td bgcolor="#F7F7E7" style='background:#F7F7E7;padding:1.5pt 1.5pt 1.5pt 1.5pt'>
<p class=MsoNormal><font size=2 face="Times New Roman"><span
style='font-size:10.0pt'>41051</span></font><o:p></o:p></p>
</td>
</tr>
<tr>
<td bgcolor="#F7F7E7" style='background:#F7F7E7;padding:1.5pt 1.5pt 1.5pt 1.5pt'>
<p class=MsoNormal><font size=2 face="Times New Roman"><span
style='font-size:10.0pt'>GUTAPP</span></font><o:p></o:p></p>
</td>
<td bgcolor="#F7F7E7" style='background:#F7F7E7;padding:1.5pt 1.5pt 1.5pt 1.5pt'>
<p class=MsoNormal><font size=2 face="Times New Roman"><span
style='font-size:10.0pt'>V_UTWATPIP_BASE</span></font><o:p></o:p></p>
</td>
<td bgcolor="#F7F7E7" style='background:#F7F7E7;padding:1.5pt 1.5pt 1.5pt 1.5pt'>
<p class=MsoNormal><font size=2 face="Times New Roman"><span
style='font-size:10.0pt'>GEOMETRY</span></font><o:p></o:p></p>
</td>
<td bgcolor="#F7F7E7" style='background:#F7F7E7;padding:1.5pt 1.5pt 1.5pt 1.5pt'>
<p class=MsoNormal><font size=2 face="Times New Roman"><span
style='font-size:10.0pt'>41051</span></font><o:p></o:p></p>
</td>
</tr>
</table>
<p class=MsoNormal><font size=2 face="Times New Roman"><span style='font-size:
11.0pt'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face="Times New Roman"><span style='font-size:
11.0pt'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face="Times New Roman"><span style='font-size:
11.0pt'>Any thoughts or insights would be appreciated.</span></font><font
size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'><o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p style='margin:0in;margin-bottom:.0001pt'><span class=style21><b><font
size=2 color=black face="Trebuchet MS"><span style='font-size:10.0pt;
color:black'>Mahalo,</span></font></b></span><font color=black><span
style='color:black'><o:p></o:p></span></font></p>
<p style='margin:0in;margin-bottom:.0001pt'><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'> <o:p></o:p></span></font></p>
<p style='margin:0in;margin-bottom:.0001pt'><span class=style21><b><font
size=2 color="#0c3181" face="Trebuchet MS"><span style='font-size:10.0pt'>Joseph
Doherty </span></font></b></span><font size=1><span style='font-size:8.5pt'><br>
</span></font><span class=style61><font size=1 face="Trebuchet MS"><span
style='font-size:8.5pt'>Software Engineer</span></font></span><o:p></o:p></p>
<p style='margin:0in;margin-bottom:.0001pt'><span class=style61><font size=1
face="Trebuchet MS"><span style='font-size:8.5pt'>Oracle Certified Professional</span></font></span><o:p></o:p></p>
<p><span class=style61><font size=1 face="Trebuchet MS"><span style='font-size:
8.5pt'>Microdesk, Inc. </span></font></span><font size=1 face="Trebuchet MS"><span
style='font-size:8.5pt;font-family:"Trebuchet MS"'><br>
<span class=style61><font face="Trebuchet MS">P: 781-419-8105 <br>
C: 781-820-1389 <br>
F: 781-890-5275 </font></span><br>
<span class=style61><font face="Trebuchet MS"><a href="http://www.microdesk.com">www.microdesk.com </a></font></span></span></font> <o:p></o:p></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
</div>
</body>
</html>