Re: Tables and ring-like data structure?

ramon_at_conexus.net (Ramon F Herrera) wrote:
> I just started to design a payroll application for several
> different companies, some of them pay weekly, others
> byweekly or monthly. We have to keep the payment info for
> every pay period. A simple example:
>
> John Smith 1234.45 1/1/2003
> 1188.92 1/15/2003
> 1252.21 2/1/2003
> [...]
> 1234.45 12/31/2003
>
> In cases like this I find the relational paradigm too restrictive.
> Being a C programmer I keep on thinking on a ring-buffer like
> in which I dont have to move all those values from a field to
> the next every payday.

Why do you have to move any values from a field to the next every payday as it is? You just have to insert one row, (name,pay,pay_date). No moving at all.

Xho

-- 
-------------------- http://NewsReader.Com/ --------------------
Usenet Newsgroup Service              New Rate! $9.95/Month 50GB