Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SEEK command
Message
From
25/04/1998 19:18:25
 
 
To
25/04/1998 08:31:11
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Miscellaneous
Thread ID:
00094815
Message ID:
00094933
Views:
38
Using the Upper() in the index is sometimes problematic because it makes Rushmore optimization a little trickier. (You have to always use the upper() in the operation.) Nonetheless, it is probably a good idea to use it with a client name. Anyway, Quinn - here's the solution all put together and guaranteed to work:

Now:
1. Select Client && Assuming client is the name of your client table
2. Index on Upper(Cl_Name) Tag UCl_name && cl_name is the client name field


Later, in your code:
1. Make sure the client table is in use in Some workarea.
2. l_lRetVal = ;
Seek(PadR(Upper(txtTextBox.Value),FSize('cl_name','clients'));
,'clients','UCl_name')

If that doesn't work, shoot me.

Adam
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform