Very Computer

1. VFP question - Index ReCreation and Persistent Relations

Hi.  Although I've done the following in 2.6, I'm relatively new to VFP and
I'm stumped due to ignorance.

What I Need:
I want to make a module that will recreate indexes from scratch.  This
would be used when the system administrator believes reindexing would be
appropriate, such as in case of a cdx being corrupted.

I've already identified and stored the expressions for each tag in each
CDX associated with a Table in my Database.  I'm currently storing that
information in the DBC's User memo field for the Index record.  My plan
is to recreate the indexes by deleting the CDX and recreating it based
on the information stored in the DBC.

I've been told that if I do this I may lose my persistent relationships.
If this is so then I'll need to store that information as well, so that
I can recreate them also.  I'm thinking that I can store this
information in the DBC in the User memo field associated with the Table
record.

My Questions:
Where is the information for the persistent relationships stored?
How can I read it programmatically, so that I can update the record I'll
be storing this in?
Am I correct that I would use the Alter Table command to recreate the
persistent relationships?

Rick Liebespach
The Omnia Group Inc.
601 South Boulevard
Tampa, Florida 33606-2677
(813) 254-9449

2. no space after delete? (thanks)

3. BULK INSERT requires index recreation ?

4. Help!!!!. What this .DBX extension database format???.

5. Index recreation takes long time

6. Benchmarks and Performance on large databases

7. recreation of DBF indexes

8. Bug with "NOT IN" subqueries

9. admitted newbie question - changing primary index key to a clustered index

10. DTS newbie question regarding indexes

11. Newbie Index Question

12. Newbie question on B-tree index levels

13. Newbie Index Question