Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Best way to index
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00355970
Message ID:
00356063
Views:
18
Hi Alan,

>
seek("ThisData") instead of Seek("ThisData      ")?
The only time you would need to add trailing spaces is if your index is on multiple fields (ie. this+that) and you're seeking both fields; then you would have to use:
seek("ThisData    "+"Thatdata   ") instead of Seek("ThisData"+"Thatdata")
Personally, I shy away from compound keys, especially for primary indices.

The one exception that comes to mind is a Last name, first name lookup where I have used TRIM(LNAME)+", "+FNAME as the key. I guess, in this case, it doesn't matter that there are trailing spaces added by VFP in the index.

HTH
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform