If you have MapBasic, then you can code it with one loop and run it. The
code below assumes your table is called "BigTable" with a "UniqueID" text
column. This code will populate your UniqueID field with 000000001000000,
000000001000001, 000000001000002, etc...
Include "MapBasic.def"
Dim i As Integer
Open Table "BigTable"
For i = 1 To TableInfo("BigTable", TAB_INFO_NROWS)
Update BigTable
Set UniqueID = "00000000" (1000000 + i)
Where RowID = i
Next
Commit Table BigTable
If you don't have MapBasic, then you can create the column in another
application, such as MS Access or Excel, and then import the table and
update the column in MapInfo.
Michael Hanna
-----Original Message-----
From: Scott Walsh [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 02, 2002 11:38 AM
To: [EMAIL PROTECTED]
Subject: MI-L AUTO INCREMENT TABLE COLUMN
Hi All,
I have over a 100,000 records and need to have a 15 digit number in one
field that I'm working with. All these values need to be unique. Does
anyone know a fast way of doing this?
Thanks in advance!
S.
---------------------------------------------------------------------
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
