edudna Posted December 22, 2008 Posted December 22, 2008 (edited) 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 Posted December 22, 2008 Posted December 22, 2008 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 Posted December 22, 2008 Posted December 22, 2008 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 Posted December 23, 2008 Author Posted December 23, 2008 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
Recommended Posts
This topic is 5815 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now