I'm a former Clipper programmer switch to VFP few years ago, I still keep my old Clipper style, when I tried to convert to SQLServer database, I asked another programmer for an advise. he said my database designed was bad, and it won't work with SQLServer database.
The main issue with my design is I always keep calculated fields, which store how many stock onhand in store, warehouses, etc, while he said I shouldn't have any calculated fields, thus avoid record locking, if I want the figure I should recalculate them from the invoices. We have argued about this issue for a long time and I don't know who is right. I can't imaging how I can recalculate 100.000 items before printing a stock onhand report.
I would like to ask for your opinion.
John
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement