Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Replace at many tables
Message
From
10/02/2005 18:04:22
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
 
 
To
10/02/2005 17:53:46
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 5
Database:
Visual FoxPro
Miscellaneous
Thread ID:
00985784
Message ID:
00985805
Views:
17
It could be almost anything.
  • "Please give me the totals per month, for the last two years."
  • "I need a report that compares the total for January [or any other month] with the same month for the last 3 years."
  • "Delete all data the previous 2 years, that satisfies a certain condition."
  • "In which month did we have the highest numbers?"

    You could go on and on... but the basic idea is that you will need to repeat this (looping through all the months), whenever you need to do anything with data for more than one month.

    It is much simpler to have data for different months in a single table. About the only reason to go the more complicated path, of separating into several months, is because there is so much data that it becomes unmanageable - especially if it tends to grow beyond the VFP limit of 2 GB limit per file.

    >BTW, what kind of purposes,
    Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
  • Previous
    Next
    Reply
    Map
    View

    Click here to load this message in the networking platform