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:
00774508
Views:
15
>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,
INDEX ON PADL(TRANSFORM(numfld),4,"0")
INDEX ON PADL(numfld,4,"0")
INDEX ON numfld 
INDEX ON STR(numfld,4)
all sort records in the same order.
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform