Clarion - totals problem

Author

totals problem

©èu

2006-01-10, 3:55 am

hi

i have problem with make something work in clarion

i have 2 browses (which browse 2 raleted tables)

1st with students
2nd with grades for classess

i need to put average grade of each student in his row in 1st browse

but whatever i do, it's not working

i've manage to put average in 2nd browse by totaling in global variable
then call it by formula

but for 1st browse it doesn't work

can somebody here help me?

thanks

sandinzz@yahoo.com

2006-01-10, 3:55 am

Hi. I'm afraid that you will have to put some code directly in the
source.
1. Find out embed point ResetFromView in studet's browse list.
2. Load the segments of the grade's key for "selected" student
3. Set the grades key: something like SET(key,key)
4. Loop through the grades file with Next() and make sum and count for
grades. Break from the loop if the students code (in grades file) is
different from students code in students list
5. Find out average grade and put it in local variable.

6. Put local variable in student list (In APP designer - List Box
Format)
Hope that wil help you to solve your problem!

Sponsored Links