Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Bug? Index Transform(numfld) tag numa
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00774473
Message ID:
00774507
Views:
14
Jim,

Thank you, I have been trying to find the a way of getting an incremental search to work on a numeric 4,0 field in a grid. I will have numbers like 250, 350, 650, 6300. The index
PADR(TRANSFORM(numfld),4)
will bring me to the 6300 before the 650. I believe I have the answer to the seek now. I'll have to index
PADL(TRANSFORM(numfld),4,"0")
Then seek on according to what Sergey suggested.

Tracy
Tracy
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform