Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Index doesn't work after deleting records
Message
From
18/06/2002 17:14:12
 
 
To
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:
00669912
Views:
17
>Earl,
>
>1) Did you just delete the records or did you PACK the table afterwards?

I deleted and then Packed.

>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?

By hammer I mean that it no longer finds the records in the index.


>3) What version of VFP7 are you running - original or SP1?

VFP7.0 SP1

>4) What are your EXACT
>---a) index TAG expressions;
index is a regular index named cUser = TTOC(timein)+cID
>---b) command that 'hammers' the index?
seek no longer works
>
>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