Re: HELP: How to generate sequential Primary Keys on a master-detail form?

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Fri, 05 Apr 2002 20:48:48 +0200
Message-ID: <6asrau4lfelqqtptocr3h3hqbt1ccdncth_at_4ax.com>

[Quoted] [Quoted] On Mon, 01 Apr 2002 16:09:51 GMT, IF <tlfbi98_at_terra.es> wrote:

>We have a master-detail form and we need to generate sequential
>primary keys values for the records of the master block just before
>inserting them into the database.
>
>We cannot use Oracle Sequences because we cannot lose any value in the
>sequence. Therefore, in order to generate the sequential values for
>the primary key, we have to use a value stored in another table.

[Quoted] rubbish. Create sequence ... nocache ordered.

Regards

[Quoted] Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Fri Apr 05 2002 - 20:48:48 CEST

This message: [ Message body ]
Next message: David Collier: "Validate Data Entry -How do I create "Password" type edit box :Forms 6i"
Previous message: Thomas Kyte: "Re: L:ist - Can do/do better in MS SQL than Oracle"
Next in thread: Philip Chee: "Re: HELP: How to generate sequential Primary Keys on a maste"
Reply: Thomas Kyte: "Re: HELP: How to generate sequential Primary Keys on a master-detail form?"
Reply: Philip Chee: "Re: HELP: How to generate sequential Primary Keys on a maste"
Maybe reply: Niall Litchfield: "Re: HELP: How to generate sequential Primary Keys on a master-detail form?"
Maybe reply: NOSPAM: "Re: HELP: How to generate sequential Primary Keys on a master-detail form?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message