READ-XML failing with errors 87 and 13052 when boolean value

Posted by papalee_abb on 08-Jan-2020 17:23

Is there a way to tell READ-XML to accept 1 and 0 as valid XML boolean values mapped to a logical temp-table field?

XSD:

 <xsd:element name="DropShip" type="xsd:boolean" nillable="true"/>

XML:

  <DropShip>0</DropShip>

This scenario fails with "Input value: 0 should be yes/no. (87)" and "Unable to convert XML to native data type for field 'DropShip' in table │ 'tt-OrderHeader'. (13052)".

Given 1 and 0 are valid boolean values per XML standards this is unexpected behavior - IMO.

TIA

Posted by Robin Brown on 08-Jan-2020 19:51

I agree that this is a bug.  Please log it with Tech Support.

Regards,

Robin

All Replies

Posted by Robin Brown on 08-Jan-2020 19:51

I agree that this is a bug.  Please log it with Tech Support.

Regards,

Robin

Posted by papalee_abb on 09-Jan-2020 17:24

Case logged with Tech Support

This thread is closed