Re: Impossible Database Design?

From: x <x_at_not-exists.org>
Date: Wed, 17 May 2006 11:41:32 +0300
Message-ID: <e4enfi$l28$1@emma.aioe.org>

"Nikolai Onken" <nikolai.onken_at_gmail.com> wrote in message news:1147793576.656483.275490_at_j73g2000cwa.googlegroups.com...
> Hey,
>
> I was just wondering if it is possible to create a database design
> where you can have
>
> 1. Infinite repeating events like "every year, every last monday,..."
>
> 2. The possibility to test whether events overlap other events
>
> I would say it is not possible since I would need to run an infinite
> query to catch a singular event..
> Any ideas?
> What would be the 'nearest' approach?
> Cheers,

It's easy.
Ask your client what events will want to store in the computer and what is the best way for him to input that data. Work from there. Received on Wed May 17 2006 - 03:41:32 CDT