Retrieving db-trigger modified items

From: Lío <jgonzalezsuareNO_at_SPAMnexo.es>
Date: Mon, 14 Aug 2000 16:22:20 +0200
Message-ID: <o9nfpskaojemso28p9e16as1ikqb69ms35_at_4ax.com>


Hello.
I'm migrating my forms from 4.5 to 6i.
I have some forms based on a table whose primary key is formed by a text code column and a number code column (sequential for the text code). For example:

Documentation table:

Cod_doc VARCHAR2(5),
Num_rev NUMBER(3),
Dat_cre DATE,
Tex_doc	LONG,

etc.

Thus, the primary key here is COD_DOC and NUM_REV. Num_rev is increased for each document when a new release of the document is issued, and I generate this num_rev from a Before insert db-trigger.
So, when the user inserts a new release of a document, I have to retrieve the num_rev in a post-forms-commit trigger, and put it into a query-only display item for he to see it. I think this is not very smart, and, during the 6i installation I think I read that this new version has an *automatic* way to do this, but I forgot where I read it. Do you know something about all this?

Thanks.

--
Julio César Glez Suarez
Xixón, Asturies, Spain
jgonzalezsuareNO_at_SPAMnexo.es (Remove NO SPAM)
Received on Mon Aug 14 2000 - 16:22:20 CEST

Original text of this message