Rick Schummer wrote: > DELETE TAG ALL and INDEX ON will solve the problems discussed, and has been a > best practice for > years. It also will cause problems for you because it will drop persistent > relations and referential > integrity. This is why Stonefield Database Toolkit is a must have. It does > everything for you and is > easy to use. > Totally agree. We bought the product a few years ago and it has saved me loads of time updating structures etc. Well worth the money. I can show you how much code is needed for updating structures and reindexing.
I have a reindex routine I used for Pegasus Opera I when they were just standalone tables. I deleted the .cdx first and ignored the error after opening it. You could create from the SEQDBFS definitions. Wouldn't do that now as it is part of a DBC. You could knock one up using the DELETE TAG ALL and INDEX ON as suggested above, as long as you have the index information available to do it. Cheers Peter _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
