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]
