Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Tables
Message
From
15/06/2004 09:58:56
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
 
 
To
14/06/2004 17:42:30
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Re: Tables
Miscellaneous
Thread ID:
00913185
Message ID:
00913859
Views:
12
>hi,
>
>thank you for reply,
>
>i send example to your ps email.
>thanks.
>
>regards

The field No in table Tab2, for example, is that supposed to be Arabic characters? How do I show it correctly? This is more out of curiosity; I don't read Arabic.

I think I can confirm what I commented in my previous message:

The same information repeats for several months, for example:
year1   month1    amount1
2004       1      33,2208
2004       2      33,2208
...
2004       12     33,2208
This is easy for finding the data through a program, but it is too much work for the user to enter the data in the first place (or for the programmer to automate it), and to make corrections later.

I suggest you store information only when the amount changes.

For exmaple, let's assume that you start with the amount1 indicated above, for January 2004, and then, in January 2005 there is a change in amount1. You only need two records:
year1   month1    amount1
2004       1      33,2208
2004       12     35,0000
If you have another criteria (like your field no), you will have to repeat for each "no".
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