Re: Multi record problem
Date: Thu, 11 Feb 1999 09:41:22 GMT
Message-ID: <79u8k0$f0c$1_at_nnrp1.dejanews.com>
In article <79tp4s$1sr$1_at_nnrp1.dejanews.com>,
martinez_at_kki.net.pl wrote:
> One block is multi row. I want to alow user to choose
> different values from LOV (other form) and inset into
> this block. But it is important to not allow inserting
> the same value more than once. How to check it while
> commiting ?
Can you define a unique index to enforce the rule in the database? If not, that kind of validating is usually done easiest in post-forms-commit trigger, where you can read the database as it would be after the transaction but the data is not committed yet. Raising form_trigger_failure there rolls back the transaction.
-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Thu Feb 11 1999 - 10:41:22 CET