Cindy,

This thread seems to be an interesting one: Databases,Tables, Views, Indexing and SQL syntax Re: Is the Pack command really dangerous? Thread #451943 Message #452295. I didn't find the thread I mentioned.

I also like the idea of selecting into table order by Primary key.

Just curious, does Stonefield have a demo version with code included? I guess, not :)

>Nadya,
>
>I searched on "pack" and "database" and ran across the discussion you seem to be referring to.
>
>Seems that the "dangerous" action is not so much PACK as DELETE TAG ALL because the persistent relationships will be broken when the indexes are deleted. Stonefield's makes sure that all of this is done/rebuilt properly.
>
>
>>>First of all, sorry, if this question was asked before. I just don't know, how to search the necessary thread. Searching by "PACK" gave me >3000 threads...
>>>
>>>I want to implement pack command in VFP database. I vaguely remember Ed Rauh's response about how it should be done correctly. Could somebody advise (with code samples, if it's possible), what's the best way of implementing "PACK" command in a Database.
>>>
>>>I know about Stonefield, but unfortunately, we haven't choosen it in the first place and therefore now it's not an option :(