Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Listbox Speedsearch not working for 3 chars only
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00912914
Message ID:
00913403
Views:
14
Thanks for the information Barabara. However, I tried the select statement and changed the type to SQL statement but I get the same results. The first time I press the 'A' it appears to go to it, but subsequent times it fails. The same for the other two letters although there are clearly many records beginning with those letters. I also ordered the sql by pr_name of course. Eventually, after pressing letters (C, D, O, etc) more than about 5 times it stops jumping to those records at all but just sits on the current item in the listbox.

>I'm surprised this is working at all. I would expect you to be getting a '"field" phrase is not found' error with that combination of RowSourceType and RowSource. When you use a RowSourceType of "Fields", it expects the RowSource to specify fields in the format alias.field,field,field. You're only using a single field, but there's no alias. And I don't think VFP likes having an expression there either.
>
>If you switch your RowSourceType to 3 - SQL Statement and change the RowSource to [SELECT PR_NAME+LEFT(PR_ADDR1,18)+' '+PR_SYSNUM+' '+trans(PR_PHONE,"@R (999) 999-9999") FROM SomeAlias INTO CURSOR Junk] I'll bet it works.
.·*´¨)
.·`TCH
(..·*

010000110101001101101000011000010111001001110000010011110111001001000010011101010111001101110100
"When the debate is lost, slander becomes the tool of the loser." - Socrates
Vita contingit, Vive cum eo. (Life Happens, Live With it.)
"Life is not measured by the number of breaths we take, but by the moments that take our breath away." -- author unknown
"De omnibus dubitandum"
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform