But, if you have updated a column with the ROWID these values will not change when packing a table.
Peter Horsb�ll M�ller GIS Developer Geographical Information & IT COWI A/S Rug�rdsvej 55 DK-5000 Odense Denmark Tel +45 6313 5013 Direct +45 6313 5008 Mob +45 5156 1045 Fax +45 6313 5090 E-mail [EMAIL PROTECTED] http://www.cowi.dk COWI GIS konference afvikles i dagene d. 2.-3. september. Se yderligere oplysninger p� www.cowi.dk/Div04/Profiles/nyheder.asp > -----Original Message----- > From: Ian Tidy [mailto:[EMAIL PROTECTED] > Sent: Wednesday, July 30, 2003 10:47 PM > To: 'Gerasimtchouk, Renee'; [EMAIL PROTECTED] > Cc: MapInfo-L > Subject: RE: MI-L Auto Increment > > > 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 > --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 7838
