Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Seek not working intermittently
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
01411359
Message ID:
01411498
Views:
35
Gerard,

You can also use indexseek() especially if you are only doing an existence check and don't actually need to move the record pointer in the lookup table before you dosomething.

>Thanks Sergey for your reply.
>I have recreated the indexes and will check this evening if this sorts the problem.
>If it was a corrupt index, I would have expected to see more (rathet than very intermittent) problems

>>In my experience only corrupted indexes could cause incorrect SEEK results.
>>
>>BTW, you can shorten code by using SEEK() function
>>
>>IF SEEK(Cur.MyField, "MyLookup", "MyOrder")
>>  Do something
>>ENDIF
>>
df (was a 10 time MVP)

df FoxPro website
FoxPro Wiki site online, editable knowledgebase
Previous
Reply
Map
View

Click here to load this message in the networking platform