General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only