Herr Doktor, Fritz, I think this could be of some use to you. I don't 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 Razzak's Virtual Autonum work, because I have used
that at times, too, when I needed to number rows in a result-set.
Hope this helps & Mach's 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 :)
Fritz
