Retrieving db-trigger modified items
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