[prev in list] [next in list] [prev in thread] [next in thread]
List: fdo-users
Subject: [fdo-users] RE: SQLServerSpatial, same layer in multiple schemas
From: Brent Robinson <brent.robinson () autodesk ! com>
Date: 2009-12-03 2:30:52
Message-ID: E904795F247888499B9A49F88DEBA1DE3D5F220AAA () ADSK-NAMSG-01 ! MGDADSK ! autodesk ! com
[Download RAW message or body]
[Attachment #2 (multipart/alternative)]
I did a quick test describing a schema from the SQLServerSpatialProvider an=
d called GetQualifiedName on one of the classes retrieved and the schema n=
ame was included in the qualified name. The GetQualifiedName implementation=
is provider-independent; if the class has a parent schema then the schema =
name is included.
One thing worth checking would be whether your feature class has a parent. =
This can be done by calling FdoClassDefinition::GetParent() or by checking =
the m_parent member in a debugger.
From: fdo-users-bounces@lists.osgeo.org [mailto:fdo-users-bounces@lists.osg=
eo.org] On Behalf Of Chris Erickson
Sent: Wednesday, December 02, 2009 10:09 AM
To: FDO Users Mail List
Subject: [fdo-users] RE: SQLServerSpatial, same layer in multiple schemas
Both came from FdoIDescribeSchema
[cid:image001.png@01CA7396.B29CCE70]<http://www.cartopac.com/>
chris erickson
developer
chris@cartopac.com<mailto:chris@cartopac.com>
970.493.9500 x 191
970.482.1485 (fax)
From: fdo-users-bounces@lists.osgeo.org [mailto:fdo-users-bounces@lists.osg=
eo.org] On Behalf Of Brent Robinson
Sent: Monday, November 30, 2009 10:59 AM
To: FDO Users Mail List
Subject: [fdo-users] RE: SQLServerSpatial, same layer in multiple schemas
Where does the feature class originate from? I had a look at the two spots =
( FdoIDescribeSchema and FdoFeatureReader) where it can be retrieved from t=
he provider. Was it from one of these or from a third place?
From: fdo-users-bounces@lists.osgeo.org [mailto:fdo-users-bounces@lists.osg=
eo.org] On Behalf Of Chris Erickson
Sent: Monday, November 30, 2009 12:33 PM
To: FDO Users Mail List
Subject: [fdo-users] RE: SQLServerSpatial, same layer in multiple schemas
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->Qualified=
Name. For SDE, it returns SCHEMA::TABLE, for SqlServer it returns TABLE.
[cid:image001.png@01CA7396.B29CCE70]<http://www.cartopac.com/>
chris erickson
developer
chris@cartopac.com<mailto:chris@cartopac.com>
970.493.9500 x 191
970.482.1485 (fax)
From: fdo-users-bounces@lists.osgeo.org [mailto:fdo-users-bounces@lists.osg=
eo.org] On Behalf Of Brent Robinson
Sent: Monday, November 30, 2009 9:53 AM
To: FDO Users Mail List
Subject: [fdo-users] RE: SQLServerSpatial, same layer in multiple schemas
Was the class definition retrieved from another Feature Reader ( FdoIFeatur=
eReader::GetClassDefinition())? If you do something like the following:
* Create an FdoISelect command using the SQLServerSpatial provider
* Set some properties for the select
* Execute the select
* Get the class definition from the resulting feature reader.
The class definition will be parentless and GetQualifiedName() will return =
just the class name.
From: fdo-users-bounces@lists.osgeo.org [mailto:fdo-users-bounces@lists.osg=
eo.org] On Behalf Of Chris Erickson
Sent: Monday, November 30, 2009 9:48 AM
To: FDO Users Mail List
Subject: [fdo-users] RE: SQLServerSpatial, same layer in multiple schemas
Class->QualfiedName()
[cid:image001.png@01CA7396.B29CCE70]<http://www.cartopac.com/>
chris erickson
developer
chris@cartopac.com<mailto:chris@cartopac.com>
970.493.9500 x 191
970.482.1485 (fax)
From: fdo-users-bounces@lists.osgeo.org [mailto:fdo-users-bounces@lists.osg=
eo.org] On Behalf Of Brent Robinson
Sent: Monday, November 23, 2009 8:30 AM
To: FDO Users Mail List
Subject: [fdo-users] RE: SQLServerSpatial, same layer in multiple schemas
Hi Chris,
Which function do you call to retrieve the qualified feature class name?
Brent.
From: fdo-users-bounces@lists.osgeo.org [mailto:fdo-users-bounces@lists.osg=
eo.org] On Behalf Of Chris Erickson
Sent: Monday, November 23, 2009 10:27 AM
To: FDO Users Mail List
Subject: [fdo-users] RE: SQLServerSpatial, same layer in multiple schemas
Actually, a correction.
ArcSDE returns SCHEMA:Table for the qualified name on a feature class, wher=
eas sqlserverspatial omits the schema name.
Is this just a defect in the sqlserverspatial provider?
[cid:image001.png@01CA7396.B29CCE70]<http://www.cartopac.com/>
chris erickson
developer
chris@cartopac.com<mailto:chris@cartopac.com>
970.493.9500 x 191
970.482.1485 (fax)
From: fdo-users-bounces@lists.osgeo.org [mailto:fdo-users-bounces@lists.osg=
eo.org] On Behalf Of Chris Erickson
Sent: Monday, November 23, 2009 8:25 AM
To: FDO Users Mail List
Subject: [fdo-users] RE: SQLServerSpatial, same layer in multiple schemas
Brent,
That works for sqlserverspatial, but then breaks other providers, I.E. ArcS=
DE.
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 s=
chema name is SCHEMA, not DB_SCHEMA...
I don't want to have to write provider specific case statements here, but d=
on't know what else to do.
Thoughts?
[cid:image001.png@01CA7396.B29CCE70]<http://www.cartopac.com/>
chris erickson
developer
chris@cartopac.com<mailto:chris@cartopac.com>
970.493.9500 x 191
970.482.1485 (fax)
From: fdo-users-bounces@lists.osgeo.org [mailto:fdo-users-bounces@lists.osg=
eo.org] On Behalf Of Brent Robinson
Sent: Thursday, November 19, 2009 2:22 PM
To: FDO Users Mail List
Subject: [fdo-users] RE: SQLServerSpatial, same layer in multiple schemas
Hi Chris,
Try "Schema:Parcels". Fdo uses ":" as the delimiter between schema and clas=
s name parts.
Brent.
From: fdo-users-bounces@lists.osgeo.org [mailto:fdo-users-bounces@lists.osg=
eo.org] On Behalf Of Chris Erickson
Sent: Thursday, November 19, 2009 3:31 PM
To: FDO Users Mail List
Subject: [fdo-users] SQLServerSpatial, same layer in multiple schemas
All,
I have a database with a layer (Parcels) which exists in 2 schemas. On a se=
lect command, when you call SetFeatureClassName and hand in the class's qua=
lified name, it hands in an (unqualified) name of 'Parcels'. An error is th=
en thrown "class parcels found in multiple schemas".
I've tried further qualifying the name ("Schema.Parcels") but then get an e=
rror that it can't be found. I've also tried setting the user's default sc=
hema.
Does anybody know a workaround to this?
[cid:image001.png@01CA7396.B29CCE70]<http://www.cartopac.com/>
chris erickson
developer
chris@cartopac.com<mailto:chris@cartopac.com>
970.493.9500 x 191
970.482.1485 (fax)
[Attachment #5 (text/html)]
<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: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;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.EmailStyle29
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.EmailStyle30
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.EmailStyle31
{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="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='color:#1F497D'>I did a quick test describing a
schema from the SQLServerSpatialProvider and called GetQualifiedName on one of
the classes retrieved and the schema name was included in the qualified name.
The GetQualifiedName implementation is provider-independent; if the class has a
parent schema then the schema name is included. <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'>One thing worth checking would
be whether your feature class has a parent. This can be done by calling \
FdoClassDefinition::GetParent() or by checking the m_parent member in a \
debugger.<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> Wednesday, December 02, 2009 10:09 \
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'>Both came from
FdoIDescribeSchema<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_i1030" src="cid:image001.png@01CA7396.B29CCE70"
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 30, 2009 10:59 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'>Where does the feature class
originate from? I had a look at the two spots ( FdoIDescribeSchema and
FdoFeatureReader) where it can be retrieved from the provider. Was it from one
of these or from a third place?<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>
<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 12:33 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'>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_i1025" src="cid:image001.png@01CA7396.B29CCE70"
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 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_i1026" src="cid:image001.png@01CA7396.B29CCE70"
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_i1027" src="cid:image001.png@01CA7396.B29CCE70"
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_i1028" src="cid:image001.png@01CA7396.B29CCE70"
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@01CA7396.B29CCE70"
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>
["image001.png" (image/png)]
_______________________________________________
fdo-users mailing list
fdo-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/fdo-users
--===============1598225958==--
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic