Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Set key
Message
From
20/09/1998 02:22:57
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Miscellaneous
Thread ID:
00138717
Message ID:
00138761
Views:
26
Hiya Bud ---

Is show fk a filtered or unique index?

>I am playing around with set key vs set filter and ran across this. I set key then seek on a different tag and it fails. I set filter and seek and it works.
>
>*Sample code
>use exhiinfo
>set order to showfk
>set key to 6
>?seek(3, 'exhiinfo', "Accnum") && fails
>
>set order to accnum
>* this will locate a recordd that is outside the set key range
>?seek(3, 'exhiinfo', "Accnum")
>
>set key to
>
>set filter to showfk = 6
>locate
>?seek(3, 'exhiinfo', "Accnum") && this works
>
>Anybody seen this before. Am I using set key wrong?
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform