Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Index doesn't work after deleting records
Message
From
18/06/2002 16:38:12
 
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00669892
Message ID:
00669899
Views:
20
Earl,

1) Did you just delete the records or did you PACK the table afterwards?
2) What do you mean by "...this operation hammers the index."?... What 'operation'?... By 'hammer' do you mean breaks or do you mean seems to read it inordinately muchly?
3) What version of VFP7 are you running - original or SP1?
4) What are your EXACT
---a) index TAG expressions;
---b) command that 'hammers' the index?

good luck



>Hi,
>
>I have a table that has 2 indexes. All this table does is track the login and logout times of the users. I went in and deleted a bunch of old records and then it quit working. It appears that this operation hammers thes index. Any ideas what might be causing this. I just switched the app from VFP5 to VFP7 if that matters.
>
>Thanks,
>Earl
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform