My original post was: ---------- Does anybody know a way of packing tables in batch mode? I have about 3 thousand to go through. Also, are there any known problems with data integrity when packing tables? I'd hate to pack everything and then find out 6 months or a year from now I've lost data. Or worse yet, not notice at all. ---------- and there was a flood of responses. Several people sent code, and Eric Frost programmed something on the spot. A few more mentioned how to capture MI code for making my own. To keep the size of this post down, I'll simply put the coders' email addresses at the bottom (so you can contact them for the code). I've not yet tested all the code/progams so I don't have any recommendations. To capture code, open a Mapbasic window and then pack a table the usual way. Then cut & paste, modify to your situation. Thanks to Dyan Catamaran [[EMAIL PROTECTED]] and andrew whittam [[EMAIL PROTECTED]] --- On Data Integrity --- There is a data 'loss' problem if you use adjusted dynamic labels. In this context 'adjusted' means you modify the position of an automatic label. When a dynamic label is adjusted, the adjustments are stored in the workspace with a pointer to the source table and record row. When a table is packed, the number of rows changes, and thus the relative position of the record. Workspaces are not notified when table changes are made, and so the customized labels no longer point to the correct record. The obvious fix is for MapInfo to implement an automatic record id code for all records, and then index by RecID instead of row number. Implimenting a scheme like this would probably mean wide spread changes throughout MI, so don't look for a fix from MI anytime soon. You'll just have to live with kludges. I was not informed of any other fixes or work arounds. Thanks go to Trey Pattillo [[EMAIL PROTECTED]] and John Schlosser [[EMAIL PROTECTED]]. John has a web page at http://www.sgsi.com/labe0598.htm which gives an in-depth discussion of various labeling "tips, tricks & traps". I was not informed of any other data integrity issues and two (of ten) respondents said they have never lost any data. The other eight simply did not say. --- Code & Toolboxes --- These people all sent sample Mapbasic code or toolboxes. Contact them to see what they have to offer. I think if all these people collaborated we might have a really useful and well developed tool on our hands. [nudge-nudge-wink] Carol Sheehan [[EMAIL PROTECTED]], toolbox (pack all tables) Sam Kome [[EMAIL PROTECTED]], toolbox (packrat) Eric Frost [[EMAIL PROTECTED]], toolbox (packer) Herve DORIER [[EMAIL PROTECTED]], code Trey Pattillo [[EMAIL PROTECTED]], toolbox with code (http://www.wap3.com/download/BTCHPACK.ZIP) Thanks to everybody who responded and I hope I didn't forget anybody. If anybody has an automatic method of identifying which tables have associated adjusted dynamic labels I'd appreciate it. cheers, -matt ---------------------------------------------------------------------- To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
