Sean,

Try something like the following:

_____________________________

include "mapbasic.def"
dim i, num as integer


num = TableInfo("YOUR TABLE",Tab_info_nrows)

for i = 1 to num

fetch rec i from YOUR TABLE
 update YOUR TABLE
 set id = i
 where rowid = i

next

____________________________________

Gareth Hardman
Saturn Technologies


----- Original Message ----- 
From: Sean Ramsay <[EMAIL PROTECTED]>
To: MAPINFO-L <[EMAIL PROTECTED]>
Sent: Tuesday, October 12, 1999 7:34 PM
Subject: MI Add record numbers?


>   Hi everyone,
> 
>   I'm an Arcview turned Mapinfo user here.  Hopefully, this confession
> will get some answers to my question.  What I need to do is add a unique
> id number to every record in a table.  Similar to the 'addrecno' script
> in Arcview.  I remember one little command does exist in Mapinfo to do
> this but it eludes my mind.  Can't find a single hint in the
> documentation as well.    Anyone have any tips?  Thanks in advance for
> your time.
> 
> Cheers,
> Sean
> 

----------------------------------------------------------------------
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]

Reply via email to