Re: Check uniqueness of primary key
Date: Fri, 07 Aug 1998 12:56:25 GMT
Message-ID: <6qethq$os7$1_at_nnrp1.dejanews.com>
Am i missing something here?, oracle will do the check upon the insert(unless deferred constraint checking is turned on but thats another story), so upon insert it will make sure that the pk is unique, if you want to check it at client side of form BEFORE the insert, I don't know, have not had opportunity to do any forms work since version 3 on unix side(about 4 years ago).
In article <35C9B036.5BBEA761_at_alcatel.be>,
Luc Loodts <luc.loodts_at_alcatel.be> wrote:
> Hi all,
>
> I have created a tabular form with a column that has the unique key
> property set to TRUE.
> No I am wondering how I can check the uniqueness of the primary key
> value immediately
> after it is entered by the operator (before commit is done).
> I know how to check it against the values that are already in the
> database, but I also want to
> check the uniqueness against the values entered in the form before, but
> still not commited to
> the database.
>
> Many Thanks,
> Luc Loodts.
>
>
-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Fri Aug 07 1998 - 14:56:25 CEST