Re: Biztalk Promoted Fields in SQL Schema

If you're using a SQL string literal to insert your schemas, you need to
escape the single quotes anywhere they occur in the string by using double
quotes.

Cheers,
Bob

"Neal Walters" <NealWalters@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:ECD78F81-E1B2-42F3-8D3E-9D2987FB5031@xxxxxxxxxxxxxxxx
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: Need Statement Help?
    ... I'm guessing that what is being put in is '' not " (i.e. two single quotes, ... This would happen if lbl was a zero length ... > What is happing is that in the label field " are being put ... I would probably change the variable SQL to strSQL. ...
    (microsoft.public.access.modulesdaovba)
  • Re: display data in stored procedure from multiple tables in label con
    ... I need to display this ... thing he uses in his stored procedure as well as the automatically ... My DBA's stored procedure snipet is below. ... I've tried every combination of that line in my label and nothing seems to ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: display data in stored procedure from multiple tables in label
    ... Hey Josh, using the ordinal did the trick. ... I need to display this ... thing he uses in his stored procedure as well as the automatically ... I've tried every combination of that line in my label and nothing seems to ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Label.text not set right when called, waits for next procedure to finish.
    ... > In a VB .NET app I changed the text of a label then proceed to run a ... The label change doesn't show ... > label.text change right before the stored procedure call so that the text ... > rdr = RunProcedure ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Rook Question
    ... Steve C. Orr, MCSD, MVP ... Need to bind a value from a stored procedure that returns a ... > datagrid using .filll and databind but no such methods for a label. ...
    (microsoft.public.dotnet.framework.aspnet)
Loading