Re: Sequence Numbers - Can you read them synchronously?
From: Kim Ng <kimmng_at_eskimo.com>
Date: 1995/04/01
Message-ID: <D6CA7q.1Mu_at_eskimo.com>#1/1
Mr. Kim Ng (President)
Paradigm Computer Consulting, Inc.
20611 E. Bothell Everett Hwy. S.E., Suite 280 Bothell, WA 98012
e-mail: kimmng_at_eskimo.com Received on Sat Apr 01 1995 - 00:00:00 CEST
Date: 1995/04/01
Message-ID: <D6CA7q.1Mu_at_eskimo.com>#1/1
You can either use "seq.currval" (if you just issued "nextval") or you can look at a database view/table (I don't remember its name) that tells you the current sequence numbers (ie you don't even have to issue "nextval" which will increment the sequence).
Mr. Kim Ng (President)
Paradigm Computer Consulting, Inc.
20611 E. Bothell Everett Hwy. S.E., Suite 280 Bothell, WA 98012
e-mail: kimmng_at_eskimo.com Received on Sat Apr 01 1995 - 00:00:00 CEST