Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Total money per month
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00520396
Message ID:
00520412
Views:
14
>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
Previous
Reply
Map
View

Click here to load this message in the networking platform