• 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