cocoon-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From erikjan...@xs4all.nl>
Subject Re: General DB question
Date Tue, 13 Mar 2001 21:14:46 GMT
No such thing as a sequence in sybase.
Sybase offers columns of type "identity" to uniquely count up:

 IDENTITY columns store sequential numbers, such as invoice 
 numbers or employee numbers, automatically generated by 
 Adaptive Server. The value of the IDENTITY column uniquely 
 identifies each row in a table. 

(Sybase ASE (Adaptive Server Enterprise) v11.5)

Probably hard to map to the oracle .nextval funcionality....

hth


Erikjan





Quoting Berin Loritsch <bloritsch@apache.org>:

> 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
> 
> 



erikjan

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


Mime
View raw message