Hi there,
I have an issue with retrieving and placing child data into an xml document.
I will do my best to explain what the issue is.
I have 2 parent records. Within these parent records I have a zip code which
is a foreign key. I map to the foreign table to get the description in order
to place this in the xml doc. If the zip codes are different, the
descriptions come through fine and the xml looks exactly as I expect. If the
zip codes are the same then the description is correctly placed on the first
parent record but does not appear for the second.
Below is an example of what the xml should and and then what it does look
like.
Different Zip Codes (SuburbName is correctly display on both):
<ArrayOfPerson>
<PersonDetails PersonId="X1"><General Title="MR" Gender="J"
Surname="BAUER" ZipCode="1111" SuburbName="SUBURB 1"/></ PersonDetails >
<PersonDetails PersonId="X2"><General Title="MR" Gender="H"
Surname="POTTER" ZipCode="2222" SuburbName="SUBURB 2"/></ PersonDetails >
</ArrayOfPerson>
Same Zip Codes (SuburbName is only displayed for the first person):
<ArrayOfPerson>
<PersonDetails PersonId="X1"><General Title="MR" Gender="J"
Surname="BAUER" ZipCode="1111" SuburbName="SUBURB 1"/></ PersonDetails >
<PersonDetails PersonId="X2"><General Title="MR" Gender="H"
Surname="POTTER" ZipCode="1111"/></ PersonDetails >
</ArrayOfPerson>
Has anyone experienced this issue and/or has any suggestions to get this to
work correctly?
Thanks,
Saffa
--
View this message in context:
http://old.nabble.com/XMAPAppendRec%2C-XMAPToXMLDoc-and-nested-%28child%29-tables-tp34054174p34054174.html
Sent from the U2 - Users mailing list archive at Nabble.com.
_______________________________________________
U2-Users mailing list
[email protected]
http://listserver.u2ug.org/mailman/listinfo/u2-users
