HOw to Define our own Datatype to Child Field Elements

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › HOw to Define our own Datatype to Child Field Elements

Viewing 1 reply thread
  • Author
    Posts
    • March 14, 2006 at 10:49 PM #13169
      community-content

        What is the value in the listPrice node after the map test completes.

        You can modify the map properties and set Validate TestMap Output to false to see the actual result of the map.

        I suspect that listPrice node is empty. The SQL Money data type should be compatible with xsd:decimal
        You cannot have a decimal type node without data. You can have an empty string type node but numbers and dates must contain valid data.

      • March 16, 2006 at 1:58 AM #13170
        community-content

          There are a number ways of dealing with this.

          In the SQL query you can use ISNULL(listPrice, 0) to put zero into the field if it is null.

          You can make the listPrice a string, so a null value is ok.

          You can use Logical String and Value Mapping functoids to check for existence of data in listPrice – this will only work mif listPrice is an optional field.

          • March 14, 2006 at 8:23 PM #13171
            community-content

              Hi All,

              I have an XSD, with Field elements like listPrice,transctotal,transcprice etc…, while working with Database Functoid’s, i am not getting the value of the listprice it shows error like:

              validation error: The ‘listPrice’ attribute has an invalid value according to its data type. An error occurred at file:///C:/DOCUME~1/user39/LOCALS~1/Temp/_MapData/Sales2POS_output.xml, (1, 138).

              I think this is error is occuring because of \”Variation\” of the datatypes. how is, i am retriveing datafrom the \”PUBS\” database here datatype of the \”price\” is Money. But in my XSD the datatype is \”Decimal\” I think for this one only it gives error.

              What my request is, is there any pozble to define money datatype in our XSD to price element. or What I have to do to solve this problem.

              • March 15, 2006 at 6:04 PM #13172
                community-content

                  Thanks Greg,

                  I am getting the Empty String, like ( listPrice=\” \” ), eventhough as for your suggestion i changed the properties than also i am getting the same result.
                  so kindly sugguest another solution for this.

                  Thanks & Regards,

                  Ahmed

          • Author
            Posts
          Viewing 1 reply thread
          • The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.