- Transactions and "automatic" value fixing
- Automatic value fixing
- Automatic value fixing means that an error in data will be fixed by
operations/actions done later.
- To speed up reporting, field MEMBERCOUNT INTEGER is added into table
MEMBERTYPE . Modify membership card program so, that it fixes/updates this
field too when saves member information. Program should work so that even
if row has an false input, it (probably) will be fixed through actions
done (saving,updating) in the future.
- Transactions
- Modify function mentioned above so that even if there would be ‘a
short circuit’ between UPDATE sentences, there would be no conflicts/false
inputs in the database.
- MySQL database system does not fully support transactions, but add
these ‘safety features’ into such places that program will use them if the
system would support them . ( if (bIsTransaction ) {... ).
Back