A unique number already exists for each object. If the actual number value is unimportant simply reference ROWID as it is unique and already exists for each record. Creating a new column is not necessary doing so only seems necessary if rowid is not good enough. Take the path of least resistance! ;)

e.g.

fetch first from my_tab
special_ID = my_tab.rowid


-joe k.


Joseph F. Kelly [EMAIL PROTECTED] 781-883-4668





From: "Erin Rubio" <[EMAIL PROTECTED]>
To: "abhas" <[EMAIL PROTECTED]>,<>
Subject: RE: MI-L  numbering the objects
Date: Tue, 29 Jun 2004 10:11:49 -0400

Abhas,

After you add the ID column (Table > Maintenance > Table Structure... Add Field, type = integer), you can do a Table > Update Column:

Table to update: yourtable
Column to update: ID
Get value from: yourtable
Value: rowid

You'll have to type in 'rowid' into the value textbox.

Hope this helps,
Erin Rubio

Spatial Insights, Inc.
7635 Leesburg Pike, Falls Church, VA 22043
tel: 703.891.1008 fax: 703.891.1007
sales: 800.347.5291
www.spatialinsights.com [EMAIL PROTECTED]


-----Original Message----- From: abhas [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 29, 2004 12:16 AM To: Mapinfo-L Subject: MI-L numbering the objects


Dear All,

I want to add a column to an existing table, The new column should contain
ID number, which is to be in a sequence as per the objects in the table.
I mean the ID's can be such as......for first object in the table ID=1, for
second object in the table ID=2... and so on.
One way is to go to the table and add the numbers manually. But the objects
are in a large number to be added manually.

I will be thankful if I get a simply approach to it.

looking forward for a kind reply.

with regards,
abhas
----- Original Message -----
From: "Apers Mathieu" <[EMAIL PROTECTED]>
To: "Mapinfo-L" <[EMAIL PROTECTED]>
Sent: Tuesday, June 29, 2004 5:58 AM
Subject: RE: MI-L Multiple labels for a single object


Thanks to everyone who replied.

it looks like the simplest way will be for me to duplicate the table and
disaggregate it, which i will do

Cheers all

Mathieu Apers

-----Original Message-----
From: Uffe Kousgaard [mailto:[EMAIL PROTECTED]
Sent: Tuesday, 29 June 2004 1:20 AM
To: Mapinfo-L
Subject: Re: MI-L Multiple labels for a single object


From: "Jacques Paris" <[EMAIL PROTECTED]>

> I think that you would need to build a special table just for
> labelling by exploding (disaggregating) all your regions while keeping
> real donuts as one region. (option "retain holes in regions" of the
> "objects | disaggregate" menu command" )

This function ("retain holes") was new in MapInfo 6.5. For earlier
versions you can grab a copy of our ToolBox, which will perform the same
operation for MI 4.5 - 6.0.

Kind regards

Uffe Kousgaard
www.routeware.dk


--------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 12379 This email with any attachments is confidential and may be subject to legal privilege. If it is not intended for you please reply immediately, destroy it and do not copy, disclose or use it in any way.

---------------------------------------------------------------------
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 12383

__________________________________________________
Do You Yahoo!?
http://bb.yahoo.co.jp/


--------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 12385


--------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 12394




--------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 12477



Reply via email to