Re: HELP: Tables with unique columns in Forms 3.0

On Wed, 04 Feb 1998 12:18:54 +1000, Mark Gebbie <gebbie.mark.m_at_bhp.com.au> wrote:

>Is there a way of being able to enforce unique values in a Forms 3.0
>block?
>

There is no easy way. Each record on a multi record block is committed individually, in sequence, not as a group. And as regards -
>Surely there must be systems out there where tables can be maintained by
>users, with columns with unique values that can be changed?
A lot of design effort is put into avoiding these situations. Possible work arounds
1) add fractions to each number changed, to make them unique for the database, and have a stored procedure revert columns to whole numbers in a logical manner.
2) use an intermediate 'request to change' type table as the block table. Sort of a batch mode system. This also has the advantage giving you a record of changes made for later witch-hunts.

Regards Received on Thu Feb 05 1998 - 00:00:00 CST