Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Tables
Message
De
15/06/2004 09:58:56
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivie
 
 
À
14/06/2004 17:42:30
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Re: Tables
Divers
Thread ID:
00913185
Message ID:
00913859
Vues:
13
>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)
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform