<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:x="urn:schemas-microsoft-com:office:excel" xmlns:p="urn:schemas-microsoft-com:office:powerpoint" xmlns:a="urn:schemas-microsoft-com:office:access" xmlns:dt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882" xmlns:s="uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882" xmlns:rs="urn:schemas-microsoft-com:rowset" xmlns:z="#RowsetSchema" xmlns:b="urn:schemas-microsoft-com:office:publisher" xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" xmlns:c="urn:schemas-microsoft-com:office:component:spreadsheet" xmlns:odc="urn:schemas-microsoft-com:office:odc" xmlns:oa="urn:schemas-microsoft-com:office:activation" xmlns:html="http://www.w3.org/TR/REC-html40" xmlns:q="http://schemas.xmlsoap.org/soap/envelope/" xmlns:rtc="http://microsoft.com/officenet/conferencing" xmlns:D="DAV:" xmlns:Repl="http://schemas.microsoft.com/repl/" xmlns:mt="http://schemas.microsoft.com/sharepoint/soap/meetings/" xmlns:x2="http://schemas.microsoft.com/office/excel/2003/xml" xmlns:ppda="http://www.passport.com/NameSpace.xsd" xmlns:ois="http://schemas.microsoft.com/sharepoint/soap/ois/" xmlns:dir="http://schemas.microsoft.com/sharepoint/soap/directory/" xmlns:ds="http://www.w3.org/2000/09/xmldsig#" xmlns:dsp="http://schemas.microsoft.com/sharepoint/dsp" xmlns:udc="http://schemas.microsoft.com/data/udc" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:sub="http://schemas.microsoft.com/sharepoint/soap/2002/1/alerts/" xmlns:ec="http://www.w3.org/2001/04/xmlenc#" xmlns:sp="http://schemas.microsoft.com/sharepoint/" xmlns:sps="http://schemas.microsoft.com/sharepoint/soap/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:udcs="http://schemas.microsoft.com/data/udc/soap" xmlns:udcxf="http://schemas.microsoft.com/data/udc/xmlfile" xmlns:udcp2p="http://schemas.microsoft.com/data/udc/parttopart" xmlns:wf="http://schemas.microsoft.com/sharepoint/soap/workflow/" xmlns:dsss="http://schemas.microsoft.com/office/2006/digsig-setup" xmlns:dssi="http://schemas.microsoft.com/office/2006/digsig" xmlns:mdssi="http://schemas.openxmlformats.org/package/2006/digital-signature" xmlns:mver="http://schemas.openxmlformats.org/markup-compatibility/2006" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns:mrels="http://schemas.openxmlformats.org/package/2006/relationships" xmlns:spwp="http://microsoft.com/sharepoint/webpartpages" xmlns:ex12t="http://schemas.microsoft.com/exchange/services/2006/types" xmlns:ex12m="http://schemas.microsoft.com/exchange/services/2006/messages" xmlns:pptsl="http://schemas.microsoft.com/sharepoint/soap/SlideLibrary/" xmlns:spsl="http://microsoft.com/webservices/SharePointPortalServer/PublishedLinksService" xmlns:Z="urn:schemas-microsoft-com:" xmlns:st="" 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)">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]-->
<style>
<!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@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;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-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.MsoAcetate, li.MsoAcetate, div.MsoAcetate
{mso-style-priority:99;
mso-style-link:"Balloon Text Char";
margin:0in;
margin-bottom:.0001pt;
font-size:8.0pt;
font-family:"Tahoma","sans-serif";}
p.MsoListParagraph, li.MsoListParagraph, div.MsoListParagraph
{mso-style-priority:34;
margin-top:0in;
margin-right:0in;
margin-bottom:0in;
margin-left:.5in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
span.BalloonTextChar
{mso-style-name:"Balloon Text Char";
mso-style-priority:99;
mso-style-link:"Balloon Text";
font-family:"Tahoma","sans-serif";}
span.EmailStyle20
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:windowtext;}
span.apple-style-span
{mso-style-name:apple-style-span;}
span.EmailStyle22
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.EmailStyle23
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.EmailStyle24
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.EmailStyle25
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.EmailStyle26
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.EmailStyle27
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.EmailStyle28
{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:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.Section1
{page:Section1;}
/* List Definitions */
@list l0
{mso-list-id:1709840417;
mso-list-type:hybrid;
mso-list-template-ids:-1069007298 67698689 67698691 67698693 67698689 67698691 67698693 67698689 67698691 67698693;}
@list l0:level1
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:Symbol;}
@list l0:level2
{mso-level-tab-stop:1.0in;
mso-level-number-position:left;
text-indent:-.25in;}
@list l0:level3
{mso-level-tab-stop:1.5in;
mso-level-number-position:left;
text-indent:-.25in;}
@list l0:level4
{mso-level-tab-stop:2.0in;
mso-level-number-position:left;
text-indent:-.25in;}
@list l0:level5
{mso-level-tab-stop:2.5in;
mso-level-number-position:left;
text-indent:-.25in;}
@list l0:level6
{mso-level-tab-stop:3.0in;
mso-level-number-position:left;
text-indent:-.25in;}
@list l0:level7
{mso-level-tab-stop:3.5in;
mso-level-number-position:left;
text-indent:-.25in;}
@list l0:level8
{mso-level-tab-stop:4.0in;
mso-level-number-position:left;
text-indent:-.25in;}
@list l0:level9
{mso-level-tab-stop:4.5in;
mso-level-number-position:left;
text-indent:-.25in;}
ol
{margin-bottom:0in;}
ul
{margin-bottom:0in;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="2050" />
</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='color:#1F497D'>Now we have a chicken and egg
problem… The same code, run on 2 different providers. I can’t create the
select statement without setting the layer name I’m querying. I get the layer
name by taking IFeatureClass->QualifiedName. For SDE, it returns
SCHEMA::TABLE, for SqlServer it returns TABLE.<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<div>
<table class=MsoNormalTable border=0 cellspacing=0 cellpadding=0
style='border-collapse:collapse'>
<tr style='height:4.0pt'>
<td width=97 valign=top style='width:72.9pt;padding:0in 5.4pt 0in 5.4pt;
height:4.0pt'>
<p class=MsoNormal><a href="http://www.cartopac.com/"><b><span
style='font-size:12.0pt;color:#1F497D;text-decoration:none'><img border=0
width=78 height=69 id="_x0000_i1029" src="cid:image001.png@01CA71A8.8E9BCCA0"
alt="cid:image003.png@01C8E59D.204D9280"></span></b></a><span
style='color:#1F497D'><o:p></o:p></span></p>
</td>
<td width=541 valign=top style='width:405.9pt;padding:0in 5.4pt 0in 5.4pt;
height:4.0pt'>
<p class=MsoNormal><span style='color:#1F497D'>chris erickson</span><span
style='color:#1F497D'><o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:8.0pt;color:#595959'>developer<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:8.0pt;color:#595959'><a
href="mailto:chris@cartopac.com">chris@cartopac.com</a><o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:8.0pt;color:#595959'>970.493.9500 x
191<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:8.0pt;color:#595959'>970.482.1485
(fax)</span><span style='font-size:8.0pt;color:#1F497D'><o:p></o:p></span></p>
</td>
</tr>
</table>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
</div>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<div>
<div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'>
<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"'>
fdo-users-bounces@lists.osgeo.org [mailto:fdo-users-bounces@lists.osgeo.org] <b>On
Behalf Of </b>Brent Robinson<br>
<b>Sent:</b> Monday, November 30, 2009 9:53 AM<br>
<b>To:</b> FDO Users Mail List<br>
<b>Subject:</b> [fdo-users] RE: SQLServerSpatial, same layer in multiple
schemas<o:p></o:p></span></p>
</div>
</div>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal><span style='color:#1F497D'>Was the class definition
retrieved from another Feature Reader (
FdoIFeatureReader::GetClassDefinition())? If you do something like the
following:<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoListParagraph style='text-indent:-.25in;mso-list:l0 level1 lfo2'><![if !supportLists]><span
style='font-family:Symbol;color:#1F497D'><span style='mso-list:Ignore'>·<span
style='font:7.0pt "Times New Roman"'>
</span></span></span><![endif]><span style='color:#1F497D'>Create an FdoISelect
command using the SQLServerSpatial provider<o:p></o:p></span></p>
<p class=MsoListParagraph style='text-indent:-.25in;mso-list:l0 level1 lfo2'><![if !supportLists]><span
style='font-family:Symbol;color:#1F497D'><span style='mso-list:Ignore'>·<span
style='font:7.0pt "Times New Roman"'>
</span></span></span><![endif]><span style='color:#1F497D'>Set some properties
for the select<o:p></o:p></span></p>
<p class=MsoListParagraph style='text-indent:-.25in;mso-list:l0 level1 lfo2'><![if !supportLists]><span
style='font-family:Symbol;color:#1F497D'><span style='mso-list:Ignore'>·<span
style='font:7.0pt "Times New Roman"'>
</span></span></span><![endif]><span style='color:#1F497D'>Execute the select<o:p></o:p></span></p>
<p class=MsoListParagraph style='text-indent:-.25in;mso-list:l0 level1 lfo2'><![if !supportLists]><span
style='font-family:Symbol;color:#1F497D'><span style='mso-list:Ignore'>·<span
style='font:7.0pt "Times New Roman"'>
</span></span></span><![endif]><span style='color:#1F497D'>Get the class
definition from the resulting feature reader.<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>The class definition will be
parentless and GetQualifiedName() will return just the class name. <o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<div>
<div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'>
<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"'>
fdo-users-bounces@lists.osgeo.org [mailto:fdo-users-bounces@lists.osgeo.org] <b>On
Behalf Of </b>Chris Erickson<br>
<b>Sent:</b> Monday, November 30, 2009 9:48 AM<br>
<b>To:</b> FDO Users Mail List<br>
<b>Subject:</b> [fdo-users] RE: SQLServerSpatial, same layer in multiple
schemas<o:p></o:p></span></p>
</div>
</div>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal><span style='color:#1F497D'>Class->QualfiedName()<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<div>
<table class=MsoNormalTable border=0 cellspacing=0 cellpadding=0
style='border-collapse:collapse'>
<tr style='height:4.0pt'>
<td width=97 valign=top style='width:72.9pt;padding:0in 5.4pt 0in 5.4pt;
height:4.0pt'>
<p class=MsoNormal><a href="http://www.cartopac.com/"><b><span
style='font-size:12.0pt;color:#1F497D;text-decoration:none'><img border=0
width=78 height=69 id="_x0000_i1025" src="cid:image001.png@01CA71A8.8E9BCCA0"
alt="cid:image003.png@01C8E59D.204D9280"></span></b></a><span
style='color:#1F497D'><o:p></o:p></span></p>
</td>
<td width=541 valign=top style='width:405.9pt;padding:0in 5.4pt 0in 5.4pt;
height:4.0pt'>
<p class=MsoNormal><span style='color:#1F497D'>chris erickson<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:8.0pt;color:#595959'>developer<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:8.0pt;color:#595959'><a
href="mailto:chris@cartopac.com">chris@cartopac.com</a><o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:8.0pt;color:#595959'>970.493.9500 x
191<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:8.0pt;color:#595959'>970.482.1485
(fax)</span><span style='font-size:8.0pt;color:#1F497D'><o:p></o:p></span></p>
</td>
</tr>
</table>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
</div>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<div>
<div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'>
<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"'>
fdo-users-bounces@lists.osgeo.org [mailto:fdo-users-bounces@lists.osgeo.org] <b>On
Behalf Of </b>Brent Robinson<br>
<b>Sent:</b> Monday, November 23, 2009 8:30 AM<br>
<b>To:</b> FDO Users Mail List<br>
<b>Subject:</b> [fdo-users] RE: SQLServerSpatial, same layer in multiple
schemas<o:p></o:p></span></p>
</div>
</div>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal><span style='color:#1F497D'>Hi Chris,<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>Which function do you call to
retrieve the qualified feature class name?<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>Brent.<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<div>
<div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'>
<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"'>
fdo-users-bounces@lists.osgeo.org [mailto:fdo-users-bounces@lists.osgeo.org] <b>On
Behalf Of </b>Chris Erickson<br>
<b>Sent:</b> Monday, November 23, 2009 10:27 AM<br>
<b>To:</b> FDO Users Mail List<br>
<b>Subject:</b> [fdo-users] RE: SQLServerSpatial, same layer in multiple
schemas<o:p></o:p></span></p>
</div>
</div>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal><span style='color:#1F497D'>Actually, a correction.<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>ArcSDE returns SCHEMA:Table for
the qualified name on a feature class, whereas sqlserverspatial omits the
schema name.<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>Is this just a defect in the sqlserverspatial
provider?<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<div>
<table class=MsoNormalTable border=0 cellspacing=0 cellpadding=0
style='border-collapse:collapse'>
<tr style='height:4.0pt'>
<td width=97 valign=top style='width:72.9pt;padding:0in 5.4pt 0in 5.4pt;
height:4.0pt'>
<p class=MsoNormal><a href="http://www.cartopac.com/"><b><span
style='font-size:12.0pt;color:#1F497D;text-decoration:none'><img border=0
width=78 height=69 id="_x0000_i1026" src="cid:image001.png@01CA71A8.8E9BCCA0"
alt="cid:image003.png@01C8E59D.204D9280"></span></b></a><span
style='color:#1F497D'><o:p></o:p></span></p>
</td>
<td width=541 valign=top style='width:405.9pt;padding:0in 5.4pt 0in 5.4pt;
height:4.0pt'>
<p class=MsoNormal><span style='color:#1F497D'>chris erickson<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:8.0pt;color:#595959'>developer<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:8.0pt;color:#595959'><a
href="mailto:chris@cartopac.com">chris@cartopac.com</a><o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:8.0pt;color:#595959'>970.493.9500 x
191<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:8.0pt;color:#595959'>970.482.1485
(fax)</span><span style='font-size:8.0pt;color:#1F497D'><o:p></o:p></span></p>
</td>
</tr>
</table>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
</div>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<div>
<div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'>
<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"'> fdo-users-bounces@lists.osgeo.org
[mailto:fdo-users-bounces@lists.osgeo.org] <b>On Behalf Of </b>Chris Erickson<br>
<b>Sent:</b> Monday, November 23, 2009 8:25 AM<br>
<b>To:</b> FDO Users Mail List<br>
<b>Subject:</b> [fdo-users] RE: SQLServerSpatial, same layer in multiple
schemas<o:p></o:p></span></p>
</div>
</div>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal><span style='color:#1F497D'>Brent,<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>That works for sqlserverspatial,
but then breaks other providers, I.E. ArcSDE.<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>With ArcSDE / SQL Server the
schema name gets set to DB_SCHEMA, which then throws an error that it can’t be
found – I only assume because the actual schema name is SCHEMA, not DB_SCHEMA…<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>I don’t want to have to write
provider specific case statements here, but don’t know what else to do.<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>Thoughts?<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<div>
<table class=MsoNormalTable border=0 cellspacing=0 cellpadding=0
style='border-collapse:collapse'>
<tr style='height:4.0pt'>
<td width=97 valign=top style='width:72.9pt;padding:0in 5.4pt 0in 5.4pt;
height:4.0pt'>
<p class=MsoNormal><a href="http://www.cartopac.com/"><b><span
style='font-size:12.0pt;color:#1F497D;text-decoration:none'><img border=0
width=78 height=69 id="_x0000_i1027" src="cid:image001.png@01CA71A8.8E9BCCA0"
alt="cid:image003.png@01C8E59D.204D9280"></span></b></a><span
style='color:#1F497D'><o:p></o:p></span></p>
</td>
<td width=541 valign=top style='width:405.9pt;padding:0in 5.4pt 0in 5.4pt;
height:4.0pt'>
<p class=MsoNormal><span style='color:#1F497D'>chris erickson<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:8.0pt;color:#595959'>developer<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:8.0pt;color:#595959'><a
href="mailto:chris@cartopac.com">chris@cartopac.com</a><o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:8.0pt;color:#595959'>970.493.9500 x
191<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:8.0pt;color:#595959'>970.482.1485
(fax)</span><span style='font-size:8.0pt;color:#1F497D'><o:p></o:p></span></p>
</td>
</tr>
</table>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
</div>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<div>
<div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'>
<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"'>
fdo-users-bounces@lists.osgeo.org [mailto:fdo-users-bounces@lists.osgeo.org] <b>On
Behalf Of </b>Brent Robinson<br>
<b>Sent:</b> Thursday, November 19, 2009 2:22 PM<br>
<b>To:</b> FDO Users Mail List<br>
<b>Subject:</b> [fdo-users] RE: SQLServerSpatial, same layer in multiple
schemas<o:p></o:p></span></p>
</div>
</div>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal><span style='color:#1F497D'>Hi Chris,<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>Try “Schema:Parcels”. Fdo uses
“:” as the delimiter between schema and class name parts.<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>Brent.<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<div>
<div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'>
<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"'>
fdo-users-bounces@lists.osgeo.org [mailto:fdo-users-bounces@lists.osgeo.org] <b>On
Behalf Of </b>Chris Erickson<br>
<b>Sent:</b> Thursday, November 19, 2009 3:31 PM<br>
<b>To:</b> FDO Users Mail List<br>
<b>Subject:</b> [fdo-users] SQLServerSpatial, same layer in multiple schemas<o:p></o:p></span></p>
</div>
</div>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal><span class=apple-style-span><span style='font-size:10.0pt;
font-family:"Courier New";color:black'>All,<o:p></o:p></span></span></p>
<p class=MsoNormal><span class=apple-style-span><span style='font-size:10.0pt;
font-family:"Courier New";color:black'><o:p> </o:p></span></span></p>
<p class=MsoNormal><span class=apple-style-span><span style='font-size:10.0pt;
font-family:"Courier New";color:black'>I have a database with a layer (Parcels)
which exists in 2 schemas. On a select command, when you call
SetFeatureClassName and hand in the class's qualified name, it hands in an
(unqualified) name of 'Parcels'. An error is then thrown "class parcels
found in multiple schemas".<o:p></o:p></span></span></p>
<p class=MsoNormal><span class=apple-style-span><span style='font-size:10.0pt;
font-family:"Courier New";color:black'><o:p> </o:p></span></span></p>
<p class=MsoNormal><span class=apple-style-span><span style='font-size:10.0pt;
font-family:"Courier New";color:black'>I’ve tried further qualifying the name
(“Schema.Parcels”) but then get an error that it can’t be found. I’ve
also tried setting the user’s default schema.<o:p></o:p></span></span></p>
<p class=MsoNormal><span class=apple-style-span><span style='font-size:10.0pt;
font-family:"Courier New";color:black'><o:p> </o:p></span></span></p>
<p class=MsoNormal><span class=apple-style-span><span style='font-size:10.0pt;
font-family:"Courier New";color:black'>Does anybody know a workaround to this?<o:p></o:p></span></span></p>
<p class=MsoNormal><o:p> </o:p></p>
<table class=MsoNormalTable border=0 cellspacing=0 cellpadding=0
style='border-collapse:collapse'>
<tr style='height:4.0pt'>
<td width=97 valign=top style='width:72.9pt;padding:0in 5.4pt 0in 5.4pt;
height:4.0pt'>
<p class=MsoNormal><a href="http://www.cartopac.com/"><b><span
style='font-size:12.0pt;color:#1F497D;text-decoration:none'><img border=0
width=78 height=69 id="Picture_x0020_1"
src="cid:image001.png@01CA71A8.8E9BCCA0"
alt="cid:image003.png@01C8E59D.204D9280"></span></b></a><span
style='color:#1F497D'><o:p></o:p></span></p>
</td>
<td width=541 valign=top style='width:405.9pt;padding:0in 5.4pt 0in 5.4pt;
height:4.0pt'>
<p class=MsoNormal><span style='color:#1F497D'>chris erickson<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:8.0pt;color:#595959'>developer<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:8.0pt;color:#595959'><a
href="mailto:chris@cartopac.com">chris@cartopac.com</a><o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:8.0pt;color:#595959'>970.493.9500 x
191<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:8.0pt;color:#595959'>970.482.1485
(fax)</span><span style='font-size:8.0pt;color:#1F497D'><o:p></o:p></span></p>
</td>
</tr>
</table>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
</div>
</body>
</html>