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
I agree that this is a bug. Please log it with Tech Support.
Regards,
Robin
I agree that this is a bug. Please log it with Tech Support.
Regards,
Robin
Case logged with Tech Support