function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
GstarkeyGstarkey 

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?

SuperfellSuperfell

The returned xml is nested, so you have

<Account>

<Name>foo</Name>

...any other fields you queried for on account

</Account>

 

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

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