If your table is already organized as on the left side, one manual procedure
would be to select for each text value and update the ID with rowid of the
selection. i.e.
Select * from your_table where TEXT="X" into Sel
Update Sel Set ID = rowid
You can write these two lines in the MapBasic window, and change only the
"text" value before rerunning them.
Or write a small MB that will do it automatically.
Good luck
Jacques
Jacques PARIS
e-mail [EMAIL PROTECTED]
For MapInfo support, see the Paris PC Consult enr. site at
http://www.total.net/~rparis/gisproducts.htm
For MapBasic questions see the J.Paris site at
http://www.total.net/~jakesp/index.htm
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Kjartan Greiff
Selnes
Sent: December 19, 2000 5:48 AM
To: Mailingliste Mapinfo
Subject: MI-L Another query
Hello again Listers.
I have this table with ID and TEXT column:
ID TEXT ID TEXT
1 X 1 X
2 X This i woluld like to 2 X
3 X "reshape" to: 3 X
4 Y 1 Y
5 Y 2 Y
6 Z 1 Z
7 Z 2 Z
8 Z 3 Z
This is probably not a one step query.........
Any tips would be appriciated
Regards
Kjartan Greiff Selnes
Bravida Geomatikk AS
Norway
_______________________________________________________________________
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, send e-mail to [EMAIL PROTECTED] and
put "unsubscribe MapInfo-L" in the message body.
_______________________________________________________________________
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, send e-mail to [EMAIL PROTECTED] and
put "unsubscribe MapInfo-L" in the message body.
