Jerry, If you use this method, just be careful if you delete records and pack the table. The RowID is exactly that and if you delete records and pack the table then the RowID for the records after the deletion will be changed.
Cheers Ian Ian Tidy GIS Administrator Works Asset Napier City Council mailto:[EMAIL PROTECTED] http://www.napier.govt.nz -----Original Message----- From: Gerasimtchouk, Renee [mailto:[EMAIL PROTECTED] Sent: Thursday, 31 July 2003 6:47 a.m. To: '[EMAIL PROTECTED]'; [EMAIL PROTECTED] Subject: RE: MI-L Auto Increment If you want a sequential number, add a new column to your table w/ Integer value, then use Update Column to update this new column and type in 'rowid' into the value field. _Renee Rene� Gerasimtchouk Geographic Systems Specialist II Planning Department, rm. 400 (408)277-2294 -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 30, 2003 11:34 AM To: [EMAIL PROTECTED] Subject: MI-L Auto Increment Hey, I am looking for an easy way to auto increment a column in my table. I would like to populate a column to use as a primary key. Is there an SQL statement I could use to update my table with this data? Thanks, Jerry Bratton ole0.bmp (501) 905-8556 fax (501) 690-5741 cell (501) 905-5741 desk ###################################################################### This e-mail message has been scanned and cleared by MailMarshal ###################################################################### ###################################################################### Attention: This e-mail message and accompanying data may contain information that is confidential and subject to legal privilege. Any information provided is given in good faith. However unless specifically stated to the contrary, Napier City Council accepts no liability for the content of this e-mail or for the consequences of any action taken on the basis of the information provided, unless that information is subsequently confirmed in writing. If you are not the intended recipient, you are notified that any use, dissemination, distribution or copying of this message or data is prohibited. If you received this e-mail message in error, please notify us immediately and erase all copies of this message and attachments. Thank you. ###################################################################### --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 7832
