I am not a developer. And I have a question about a script I would like to have the database perform, but I am not sure it will work.
I have a database where I manually enter all info. After typing in the date of birth, the db calculates the age and grade.
I am working with a developer to create a script that will automatically import records from a csv file.
The plan is to do this:
Import all record info from csv to database, including Date of birth
Database calculates age and grade and either updates or leaves untouched the age and grade fields in the db
Database compares the corresponding csv age and grade fields to the (possibly) newly updated db fields
If there are any changes, take some action - not important.
The question is this:
Will the database be able to conduct these functions in order, or might the database compare the corresponding csv and db fields, before the fields have a chance to update from the calculation already set up in the db?