Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Index doesn't work after deleting records
Message
De
18/06/2002 17:14:12
 
 
À
18/06/2002 16:38:12
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00669892
Message ID:
00669912
Vues:
19
>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform