Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Total money per month
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00520396
Message ID:
00520412
Vues:
15
>To control money amount per month at a shop,
>
> Whats programatically more correct and usual
>
> Create only a table to control all months
>
> Or create a new table every month ?
>
> Jan_2001.dbf
> Feb_2001.dbf
> etc...
>
>
> I've never created this kind of application before
>
> Thanks
>
Moises,

Creating a new table for each month will lead to many headaches. Use one table, with a date field for the receipt date. For any given month/year combination, you can retrieve the pertinent records with a WHERE clause specifying the month and year.
George

Ubi caritas et amor, deus ibi est
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform