RE: [PEAR-DEV] Idea for pear sequence tables

Separate sequences are important for a number of reasons: 1) Often their are external factors driving the sequence assignment, such as a check number, or inventory tag number. 2) Sequences are often used as an audit mechanism to make sure that something strange isn't going on, or illegal entries going on. 3) GAAP practices require unique transaction numbers in AP, AR, and GL that are tied together 4) If you have one table with many records and another table with a few records, why require a number that's say 12 or fourteen digits when 4 digits would suffice. There are several other reasons. I agree that this should be one table... Thanks, Rob > -----Original Message----- > From: Tomas V.V.Cox [mailto:cox@idecnet.com] > Sent: Friday, September 12, 2003 12:36 PM > To: Stowe, Nola > Cc: pear-dev@lists.php.net > Subject: Re: [PEAR-DEV] Idea for pear sequence tables > > > On Friday, September 12, 2003 17:52, Stowe, Nola wrote: > > > I'm sure someone has thought of this and you have a good reason for NOT > > doing it.. but..I'm curious on why you didn't do it this way? > > > Instead of having another table created for each table I need a > sequence on, > > what about having a sequence table (seq_name, seq_key) with > rows for each > > table and then just fetching and updating that table with the next key? > > Well, a sequences is just that a pool of unique id's for using in your > tables. I never understood why one would like to have multiple > sequences, while just one for all your tables is enough. > > -- > Tomas V.V.Cox mailto:cox@idecnet.com > > -- > PEAR Development Mailing List (http://pear.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > >