+ Start a Discussion

How do I read child elements from a multi-table SQL query

This is my SQL statement

qr = binding.query("Select Account.Name, FirstName from Contact")


I can read FirstName


getFieldValue("FirstName", con.Any)


But the Account element only shows Account not Account.Name.


How do I read Account.Name in VB?


The returned xml is nested, so you have



...any other fields you queried for on account



So your code to read the field value for these fields needs to traverse into the nested elements.


Thx, the debugger did not show that the data was available, but it is there.