Re: Constraining table to 1 record
From: DanHW <danhw_at_aol.com>
Date: 18 Aug 1999 03:23:24 GMT
Message-ID: <19990817232324.02286.00000443_at_ng-fc1.aol.com>
Date: 18 Aug 1999 03:23:24 GMT
Message-ID: <19990817232324.02286.00000443_at_ng-fc1.aol.com>
>What is the easiest way to constrain a table to 1 record only. I have a
>table that needs only a single entry. I am using Designer 2.1.2 and
>Developer Forms 5.
>
Step 1. Create a column in the table as a unique key Step 2. Create a trigger on the table that sets the key value to 1.
This will work as long as the trigger is not disabled or dropped.
Dan Hekimian-Williams Received on Wed Aug 18 1999 - 05:23:24 CEST