[progress Communities] [progress Openedge Abl] Forum Post: How Do We Include Related Fields...

  • Thread starter Thread starter faithlessdreams
  • Start date Start date
Status
Not open for further replies.
F

faithlessdreams

Guest
Hi Team Please confirm how I can include other fields from related tables into a single rbf_selectQuery select query? if I do rbf_selectQuery("SELECT name, R267698753 FROM TestObject1", 20000, buildData); the related R267698753 returns the ID for each related R267698753. I want to return other fields of this object. The relationship is many to one. I.e. many TestObject1 can only have one R267698753. So I want to return 'name' field from R267698753 in my select query from TestObject1. Left joins or object alias do not seem to work like TSQL queries. So how do we accomplish including related data in a rbf_selectQuery select query My code :

Continue reading...
 
Status
Not open for further replies.
Back
Top