Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Should I de-normalise?
Message
De
06/10/2016 13:15:39
 
 
À
06/10/2016 10:04:19
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9 SP2
Database:
Visual FoxPro
Application:
Desktop
Divers
Thread ID:
01641691
Message ID:
01641706
Vues:
42
>It shouldn't be that difficult to normalize/denormalize. It's done all the time.
>

Does this logic fit in with how you would approach it:

User displays screen for a location and week:
I pull out all the data from the underlying normalised table and massage it into how I need it.
User updates a couple columns in one row, adds a new employee row and deletes another employee row, then saves.
In the background I will have to:
- detect what was changed in the columns and update the underlying rows in my normalised table, (if there was no entry for a particular day I'll have to add that row in)
- then insert the appropriate rows for the newly added employee and
- then delete the rows for the deleted employee

Having not done this kind of coding in years, do I use GETFLDSTATE() to detect the changes and what type of change? Or is there something easier to use?
Frank.

Frank Cazabon
Samaan Systems Ltd.
www.samaansystems.com
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform