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:
00912957
Views:
13
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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform