Re: Access / ODBC / Sequences
From: Michael Carmack <mcarmack_at_freenet.columbus.oh.us>
Date: 1996/10/04
Message-ID: <53321v$qsl_at_login.freenet.columbus.oh.us>#1/1
Date: 1996/10/04
Message-ID: <53321v$qsl_at_login.freenet.columbus.oh.us>#1/1
Pulkrab Juergen (94104066_at_fhs-hagenberg.ac.at) wrote:
: SELECT MY_SEQUENCE.CURRVAL FROM DUAL;
: Don't use MY_SEQUENCE.NEXTVAL, the sequence will increase.
Two points:
- You must call my_sequence.nextval at least once before you can use my_sequence.currval
- From his original question, it sounds like he's trying to implement an
Access "counter"-type column in Oracle, in which case using nextval (as
in the trigger I posted the other day) is the appropriate action.
--
"In sports, it's not who wins or | Mike Carmack loses; it's how drunk you get." | Vulcan Dragon -==(UDIC)==-- Homer Simpson | mcarmack_at_freenet.columbus.oh.us