David, The proper way is the first: Pack Table ....
The second shows what MapInfo actual is doing when packing a table, namely inserting the records into a new table and recreating all the index. I guess you could find an example with fewer lines, if there were no index to recreate HTH, Peter Horsbøll Møller GIS Developer, MTM Geographical Information & IT COWI A/S Odensevej 95 DK-5260 Odense S. Denmark Tel +45 6311 4900 Direct +45 6311 4908 Mob +45 5156 1045 Fax +45 6311 4949 E-mail [EMAIL PROTECTED] http://www.cowi.dk/gis -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Reid Sent: Thursday, December 29, 2005 8:40 PM To: [email protected] Subject: [MI-L] Packing a table via Mapbasic Greetings All, Quick question I hope. To pack a table including data and graphics, one simply issues the command: Pack Table [MY TABLE] Graphic Data But I notice viewing the Mapbasic Window from with MI, when a table is packed, there are 14 lines or actions carried out (EX below) so which is the proper method? Create Table "~MAP0011" .... Create Map For ~MAP0011 CoordSys .... Set Table ~MAP0011 FastEdit On Undo Off Insert Into ~MAP0011 ..... Commit Table ~MAP0011 Set Table ~MAP0011 FastEdit Off Undo On drop index [MY TABLE] (STREET) Create Index On [MY TABLE] (STREET) drop index [MY TABLE] (NAME) Create Index [MY TABLE] (NAME) drop index [MY TABLE] (CORDNBR) Create Index On [MY TABLE] (CORDNBR) drop index [MY TABLE] (OTHERNAME) Create Index On [MY TABLE] (OTHERNAME) Thanks, David Reid -- Outgoing mail is certified Virus Free Checked by AVG Free Edition. Version: 7.1.371 / Virus Database: 267.14.9/216 - Release Date: 12/29/2005 _______________________________________________ MapInfo-L mailing list [email protected] http://www.directionsmag.com/mailman/listinfo/mapinfo-l _______________________________________________ MapInfo-L mailing list [email protected] http://www.directionsmag.com/mailman/listinfo/mapinfo-l
