A script to promote students

[edudna]

I have student records belong to groups A, B, C, D, E, F.

I need a script to do all the follows in all the records:

Delete all the F students.

Delete all the grades of classes that students took with promoted grades.

Promote A to B, C to D, D to E, E to F students.

Pascal

Edited December 22, 2008 by Guest

[Søren Dyhr]

Perhaps it obvious what it is to take classes with promoted grades, but I do not get it.

SInce grades ought to be in it's own related table, isn't the selection much of a problem - GTRR(FS) after narrowing the found set down to those with promoted grades ... and then delete the related records.

To change an attribute should either be looped or dealt with via a scripted replace:

http://www.filemaker.com/help/Script-Steps52.html

...to make the promotion via a CF getting the ascii char number is a little overkill, since you overall deals with 5 levels, so a Case( must be all it takes.

--sd

[comment]

I believe it would be better to record the year of enrollment. Then the promotions would happen automatically - unless there was an exception recorded separately for a particular student.

[edudna]

Loop sometimes is very slow I do not know why and action "replace field contents" does not work when we have to change values in popup menus. However when we have to work with the enrollment year and we want to keep the old records, I believe that we have to save in the script the old file than to dublicate because we can cause a terrible mess in the database.

Pascal