Tenchi Posted October 3, 2001 Share Posted October 3, 2001 I have a script: Case (Stu_CompYear - status ( currentdate ) <= 0, "Graduate", Stu_CompYear - status ( currentdate ) <= 365, "12", Stu_CompYear - status ( currentdate ) <= 2*365, "11", Stu_CompYear - status ( currentdate ) <= 3*365, "10", "9") that converts a 4-digit graduation year into a grade value, i.e. 2003 yields 11, that I want to recalculate on September 30 of each year, so that in 2003 a graduation year of 2003 should become 12. So far, the calculation works for new records, but it doesn't update the existing records. Is there a way to force my database to recalculate values for all records? Link to comment Share on other sites More sharing options...
LiveOak Posted October 3, 2001 Share Posted October 3, 2001 In field definitions, set the calculation to unstored. -bd Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 8241 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