Hi Steve, thank´s a lot for your help J
Fritz Von: [email protected] [mailto:[email protected]] Im Auftrag von Wills, Steve Gesendet: Montag, 23. Juni 2014 15:24 An: RBASE-L Mailing List Betreff: - RE: Row Numbers in Variable Lookup List View Herr Doktor, Fritz, I think this could be of some use to you. I dont have many opportunities to help other RB-users these days, but I shared this with someone a month-or-so back. You might also search for Razzaks Virtual Autonum work, because I have used that at times, too, when I needed to number rows in a result-set. Hope this helps & Machs Gut, Steve First, create a view, using your select ... --- *** DROP VIEW vuAthletePerformanceCounts *** --- CREATE VIEW vuAthletePerformanceCounts ( SeasonCCYY, NameOfSchoolCD, Individuals_CT, Finisher_CT, AVG_Finishes_Per_Individual ) AS SELECT ir1.SeasonCCYY, ir1.NameOfSchoolCD, COUNT(DISTINCT ir1.LastFirstMiddle), COUNT(*), (COUNT(*)/COUNT(DISTINCT ir1.LastFirstMiddle)) FROM INDIVIDUAL_RESULTS ir1, COMPETITIONS c WHERE ir1.ETInSeconds <> 0 AND c.CompetitionID = ir1.CompetitionID AND ir1.NameOfSchoolCD IN ('SAA','SDS') GROUP BY ir1.SeasonCCYY, ir1.NameOfSchoolCD Then, try something like the following; notice (CVAL(RowCount)) : --- *** SAA Girls XC *** --- SELECT (CVAL('ROWCOUNT')), SeasonCCYY, NameOfSchoolCD, Individuals_CT AS Indivudal_Athlete_CT, Finisher_CT AS All_Finishes_CT FROM vuAthletePerformanceCounts WHERE NameOfSchoolCD = 'SAA' ORDER BY Individuals_CT DESC (CVAL('ROWCOUNT SeasonCCYY NameOfSc Indivudal_ All_Finish --------------- ---------- -------- ---------- ---------- 1 2013 SAA 29 197 2 2010 SAA 24 188 3 2008 SAA 23 168 4 2009 SAA 23 140 5 2011 SAA 20 115 6 2012 SAA 18 110 7 2007 SAA 14 95 8 2006 SAA 9 49 --- *** SDS Boys XC *** --- SELECT (CVAL('ROWCOUNT')), SeasonCCYY, NameOfSchoolCD, Individuals_CT AS Indivudal_Athlete_CT, Finisher_CT AS All_Finishes_CT FROM vuAthletePerformanceCounts WHERE NameOfSchoolCD = 'SAA' ORDER BY Individuals_CT DESC (CVAL('ROWCOUNT SeasonCCYY NameOfSc Indivudal_ All_Finish --------------- ---------- -------- ---------- ---------- 1 2008 SDS 23 149 2 2007 SDS 18 116 3 2010 SDS 16 127 4 2013 SDS 15 68 5 2006 SDS 13 72 6 2011 SDS 11 73 7 2012 SDS 10 61 8 2009 SDS 9 56 Also, based on one of Razzak's TECH DOCs, from quite a while back, there might be another approach, using a virtual autonum stored procedure. I have used it in the past, and I would recommend that you find it and have it at your disposal, too. Unfortunately, my attempts to use it here, today, were unsuccessful, no doubt due to some sort of ... SUM(synaptic-gap) FROM STEVEz_BRAIN WHERE Conscious_Date = .#DATE! HTH, Steve From: [email protected] [mailto:[email protected]] On Behalf Of Dr. Fritz Luettgens Sent: June 21, 2014 5:46 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Row Numbers in Variable Lookup List View Hi, I want to add Row Numbers in Variable Lookup List View on the left side of the list, but cannot find out how. I cannot find the appropriate Property command for this. I am sure there must be a fitting Property command. Thank´s for any hint J Fritz
