The following code does a fine job of returning all of the Team Codes from the Activity subform from the first “Players” record.  I’m having a struggle finding a way of getting it to return all of the Team Codes from all of the Players?  And while we're at it, is it possible to get the Team Code from only the first or top subform record from each Player record?

Any help would be appreciated.

var vRS as Int
var vCRS as Int
var vCount as Int
var vLoop as Int
var vTCode1 as string



     vRS = @XResultSetSearch(@FN, "Players", SEARCH_MODE_AND, SEARCH_SYNTAX_QA, "")    
     If vRS > -1
     {

           vCRS = @XResultSetSubSet(vRS, "Activity")
           If vCRS > -1
           {

                 vCount = @XResultSetTotal(vCRS)

                 For vLoop = 1 To vCount
                       XResultSetCurrentPosition(vCRS, vLoop)
                       vTCode1 = @XResultSetValue(vcRS, "Team Code")
                   writeln(vTCode1)
                       

                 Next
                 XResultSetClose(vRS)
           }

     }

Thanks for the response Mark.

I've tried to find a way to loop through the players without success.  I guess I just don't know how to go about it.  I've spent hours on this but just can't seem to find the right combination and placing of the loop code.

Thanks,

Brandon

Hi Mark,

Thank you for your help and I really like the way you defined each line. I need to force myself to do that for clarity.  

You’re not gonna believe this but I actually had been trying to get the same code as yours to work.  Yours didn’t work either, or so I thought.  On a whim, and thinking that your code would most certainly work, I changed the @ResultSetValue to an LE on the subform that had many more entries, and low and behold, I get a result.  So, I changed the @ResultSetValue back to the original and scrolled up in the wrtieln() window and found the “Team Code” results. I hadn’t realized before that the results were there all along, along with all the “Team Code” results that did not contain data.  So, the question now is how do I get it to show only Team Code’s that aren’t blank?  I’ve played around with @Isblank = False without success.  Any ideas?

Also, when I direct the results to a @popupchoicelist, all of the results do not get displayed at one time, just one result is shown. In order to see the rest of the results, I have to click on the popup window over and over. I don’t have this issue if I use the same popup code with search results from the parent form, only when I get results from the subform.  Any Ideas?

Regarding;  “To get the first Team Code for a Player, do not loop through all of them, index the first one and use it.”   I’m not sure how to index the first one.  I have a default sort spec to put the last entry on the top. When I remove the subform looping from the code and I add an additional team code to the subform, I get the same result, it ignores the newly added team code.  

Thank you for all of your time,

Brandon

tcgeo wrote on Oct 25^th, 2009 at 6:06pm:


Hello Brandon,

You can use XResultSetSort to sort the child result set in the same order as it's displayed on form, so the #1 record will be the one that you want.

-Ray

Do I understand correctly that vCRS (@XResultSetSubset) retrieves the child records for the @XResultSet vCR handle?

lksseven wrote on Oct 27^th, 2009 at 4:47pm:


@XResultSetSubSet() retrieves the child record(s) of the current record in the vCR XResultSet

OK, cool.  Is that an undocumented command/feature?  I couldn't find hide nor hair of it in the manuals.  But I'm glad to know it.  That opens up some possibilities for me. 

Thank you!

It is also on page 13 of the documentation Errata that can be found in the downloads area.