Re: Forms 5.0/Primary key

From: Neville Sweet <sweet.neville.nj_at_bhp.com.au.no_junk_email>
Date: Thu, 18 Nov 1999 14:31:08 +1100
Message-ID: <80vs39$95f13@atbhp.corpmel.bhp.com.au>

Henrik,

Setting Primary Key on one or more base table items ensures uniqueness of entered value/s when you attempt to navigate from a record. Without it, the uniqueness check is deferred until commit, at which time you will get a more obscure database integrity constraint error (due to your unique index). Primary Key therefore couples the form closer to the database.

Henrik-K wrote in message ...
>Hi' there !
>
>I am about to certified in developer 2.1.
>
>Studying the text item - I can't figure out what the property Primary key -
>is for ?
>
>Oracle says that it is to make a closer connection to the database. But if
I
>already made a unique index on my table - it can't get any closer than that
>or... ?
>
>Any suggestions are welcome ;-)
>
>BR, Henrik
Received on Wed Nov 17 1999 - 21:31:08 CST