Abhas I presume you mean numbering the records/rows of the table, rather than the objects (i.e. map features). So you can update the ID column with an incremental variable, something like:
Dim lnID, lnRowID as INTEGER lnID = 1 Fetch First From MyTable Do while not EOT( MyTable) lnRowID = RowID Update MyTable set IDColName = lnID where RowID = lnRowID lnID = lnID + 1 Fetch Next From MyTable Loop HTH Terry McDonnell -----Original Message----- From: abhas [mailto:[EMAIL PROTECTED] Sent: 29 June 2004 05:16 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: 12389