cocoon-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Berin Loritsch <blorit...@apache.org>
Subject General DB question
Date Tue, 13 Mar 2001 20:38:54 GMT
I want to add one more mode to the keys, so that we can
automatically specify a Sequence object.  In Oracle, the
syntax works like this:

INSERT INTO myTable VALUES (
    MySequence.NEXTVAL,
    "new thing"
);

Or if you have multiple tables that work together, it
would be like this:

INSERT INTO myTable VALUES (
    MySequence.NEXTVAL,
    "new thing"
);

INSERT INTO myOtherTable VALUES (
    MySequence.CURRVAL,
    "associated thing"
);

My question is, "Is this Oracle specific, or generic
enough to fit in the DatabaseAddAction object?".

Right now, I am working with views and triggers to
do this--but if I can bypass that I will.

---------------------------------------------------------------------
To unsubscribe, e-mail: cocoon-dev-unsubscribe@xml.apache.org
For additional commands, email: cocoon-dev-help@xml.apache.org


Mime
View raw message