Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Table index help
Message
From
20/01/2003 09:54:05
 
 
To
20/01/2003 09:36:42
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00743453
Message ID:
00743460
Views:
20
Can you please tell us information like the following:

1) Symptom observed that betrays corrupted indexes.

2) The EXACT TAG expressions for each suspect index (I assume they at structural indexes?)

3) Include for #2 any 'qualifications' (like UNIQUE) and any clauses (FOR ...).

4) Can you tell us what environment the application is running in (network OS, # concurrent users, workstation OS)

Maybe then we have a chance to help you.

good luck

>It seems that 4 of the tables in an application have index damage. The first thing I tried was to reindex and pack the tables. That did not seem to work. I then dropped the indexes from one of the tables and recreated them. That seemed to work up front but it seems that that there is something still wrong so I copied the structure and appended the records to the new table and recreated the indexes. I don't think the index correct yet. Are there any other suggestions you may may?
>
>Thanks in advance!
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform