Biztalk Promoted Fields in SQL Schema

Now I promoted some fields in Biztalk which adds "comments" in an
<annotation> tag as shown below.

<xs:element name="Hipaa30TradingTestInclude">
<xs:annotation>
<xs:appinfo>
<b:properties>
<b:property name="ns0:__Name"
xpath="/*[local-name()='Hipaa30TradingTestInclude' and
namespace-uri()='http://TestSchemas.Hipaa30TradingTestInclude']/*[local-name()='TradingPartnerCommon'
and
namespace-uri()='http://TestSchemas.TradingParterCommon']/*[local-name()='Name' and namespace-uri()='']" />
<b:property name="ns0:City"
xpath="/*[local-name()='Hipaa30TradingTestInclude' and
namespace-uri()='http://TestSchemas.Hipaa30TradingTestInclude']/*[local-name()='TradingPartnerCommon'
and
namespace-uri()='http://TestSchemas.TradingParterCommon']/*[local-name()='City' and namespace-uri()='']" />
<b:property name="ns0:State"
xpath="/*[local-name()='Hipaa30TradingTestInclude' and
namespace-uri()='http://TestSchemas.Hipaa30TradingTestInclude']/*[local-name()='TradingPartnerCommon'
and
namespace-uri()='http://TestSchemas.TradingParterCommon']/*[local-name()='State' and namespace-uri()='']" />
<b:property name="ns0:Zip"
xpath="/*[local-name()='Hipaa30TradingTestInclude' and
namespace-uri()='http://TestSchemas.Hipaa30TradingTestInclude']/*[local-name()='TradingPartnerCommon'
and
namespace-uri()='http://TestSchemas.TradingParterCommon']/*[local-name()='Zip' and namespace-uri()='']" />
<b:property name="ns0:PrimaryContact"
xpath="/*[local-name()='Hipaa30TradingTestInclude' and
namespace-uri()='http://TestSchemas.Hipaa30TradingTestInclude']/*[local-name()='TradingPartnerCommon'
and
namespace-uri()='http://TestSchemas.TradingParterCommon']/*[local-name()='PrimaryContact' and namespace-uri()='']" />
</b:properties>
</xs:appinfo>
</xs:annotation>


I have five "promoted fields" and i got the following error five times.

Msg 102, Level 15, State 1, Line 49
Incorrect syntax near 'Hipaa30TradingTestInclude'.
Msg 132, Level 15, State 1, Line 49
The label 'http' has already been declared. Label names must be unique
within a query batch or stored procedure.
Msg 132, Level 15, State 1, Line 50
The label 'http' has already been declared. Label names must be unique
within a query batch or stored procedure.
Msg 132, Level 15, State 1, Line 50

Seems like the parser should ignore anything in the <annotation> tag?
Of course, I can manually remove it, but I'm trying to plan ahead for how to
maintain this.


Thanks again,
Neal Walters
http://Biztalk-Training.com

.

Relevant Pages

  • Re: Biztalk Promoted Fields in SQL Schema
    ... Also note that XML Schema collections will not preserve your annotations. ... The label 'http' has already been declared. ... within a query batch or stored procedure. ... Seems like the parser should ignore anything in the <annotation> tag? ...
    (microsoft.public.sqlserver.xml)
  • Re: Where now for the DUP?
    ... reality of things, but just a sort of external attempt to identify ... case of the sinking of the Rainbow Warrior, as though the label, tag, ... He just clung to the label or tag ?Republican? ...
    (soc.culture.irish)
  • Re: labels using macros
    ... creates his Prouduct ID tag. ... as listed in the label tag. ... DWG. ... The problem they are in a set format. ...
    (microsoft.public.word.mailmerge.fields)
  • Re: labels using macros
    ... creates his Prouduct ID tag. ... as listed in the label tag. ... DWG. ... The problem they are in a set format. ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Label background in Mozilla with embedded html
    ... try using a literal tag and wrap the literal in a div tag so you can assign ... A label tag automatically assigns a span tag,, and I ... > The label renders in both browsers the same. ... > label has a background color. ...
    (microsoft.public.dotnet.framework.aspnet)