Uniqe Value in Combination with Dates

From: Sascha Kern <Teddy_71_at_freenet.de>
Date: Tue, 1 Oct 2002 17:43:43 +0200
Message-ID: <ancfre$8rf$02$1@news.t-online.com>

Hello

I have the following Problem.
I have a Table with this Content

DNS-Name-------------IP Adress---------------valid from----------------valid

till
.

Server1                   128.6.4.2                      05.10.2002
15.10.2002
Server2                   61.4.48.18                    01.01.2001
31.12.2001
Router1                  161.4.48.18                  01.01.2002
06.12.2003
Router2                  128.6.4.2                      20.11.2002

04.01.2003
.
.

and so on

I have to insure, if i add or modify a record, that there ist no collision with existing dates.
I think this con only be done with an insert / Update Trigger. Can someone please explain how such a Trigger looks like.

Thanks

Sascha Kern Received on Tue Oct 01 2002 - 10:43:43 CDT