> but I would be more tempted to add a seperate timestamp or > datetime column containing the time the row was inserted. Whoops. Upon reflection I don't think a timestamp column would add any more information as to the order the rows were added than the original identity column already provides. As Nic implied, do you really need consecutive IDs? Paul Ritchie. --------------------------------------------------------------------------- New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz To UnSub, send email to: [EMAIL PROTECTED] with body of "unsubscribe delphi"
- Re: [DUG]: [DUG-DB]: Unique IDs David Brennan
- RE: [DUG]: [DUG-DB]: Unique IDs Gary T. Benner
- RE: [DUG]: [DUG-DB]: Unique IDs Paul Ritchie
- RE: [DUG]: [DUG-DB]: Unique IDs Stephen Bertram
- Re: [DUG]: [DUG-DB]: Unique IDs Nic Wise
- Re: [DUG]: [DUG-DB]: Unique IDs Neven MacEwan
- RE: [DUG]: [DUG-DB]: Unique IDs Paul Ritchie
- RE: [DUG]: [DUG-DB]: Unique IDs Stephen Bertram
- Re: [DUG]: [DUG-DB]: Unique IDs Neven MacEwan
- Re: [DUG]: [DUG-DB]: Unique IDs Nic Wise
- RE: RE: [DUG]: [DUG-DB]: Unique IDs Paul Ritchie
- RE: RE: [DUG]: [DUG-DB]: Unique IDs Gary T. Benner
- RE: RE: [DUG]: [DUG-DB]: Unique IDs Paul Ritchie
- Re: RE: [DUG]: [DUG-DB]: Unique IDs Neven MacEwan
- RE: RE: [DUG]: [DUG-DB]: Unique IDs Paul Ritchie
- Re: RE: [DUG]: [DUG-DB]: Unique IDs Neven MacEwan
- RE: RE: [DUG]: [DUG-DB]: Unique IDs Paul Ritchie
- Re: RE: [DUG]: [DUG-DB]: Unique IDs Neven MacEwan
- Re: RE: [DUG]: [DUG-DB]: Unique IDs Nic Wise
- Re: RE: [DUG]: [DUG-DB]: Unique IDs Neven MacEwan
- Re: RE: [DUG]: [DUG-DB]: Unique IDs Nic Wise