Sequential Number Generator

[Rohde Dirk (Van)]

If you use Oracle for your database, then you can use Oracle sequences
within a PL/SQL procedure.  I'm not sure what other RDBs support.  Otherwise
there's no way other than storing the value in your database somewhere and
incrementing it when needed (don't forget to lock the record).

Dirk Rohde
VantagePoint Group

-----Original Message-----
From: Gassett, Chris [mailto:gassett@aavid.com]
Sent: Monday, January 11, 1999 11:19 AM
To: 'Powerhouse List'
Subject: Sequential Number Generator


Is there an easy way to code a sequential number used for keeping track of
items?  This number needs to be unique and automatically generated so the
user does not have to fish for the last number used.  Thanks in advance.
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
powerh-l@lists.swau.edu is gatewayed one-way to bit.listserv.powerh-l
This list is closed, thus to post to the list, you must be a subscriber.
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
powerh-l@lists.swau.edu is gatewayed one-way to bit.listserv.powerh-l
This list is closed, thus to post to the list, you must be a subscriber.