Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Combo box not Combo'ing
Message
From
19/03/2019 21:01:17
 
 
To
15/03/2019 17:17:11
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Miscellaneous
Thread ID:
01667274
Message ID:
01667377
Views:
82
>>>>>I left out the part between the Select and the 'Visible = 1' where I check reccount() on the cursor and I've walked the code many MANY times and yes, there are records in the cursor. For testing, I'm using a lname+fname combo that has 5 records. This label and combobox only show when there are multiple selections
>>>>>
>>>>>
>>>>>And the ALLTRIM knocks out Rushmore even if it's part of an index?
>>>>>
>>>>
>>>>What is actual index expression?
>>>
>>>ALLTRIM(UPPER(LASTNAME))+ALLTRIM(UPPER(FIRSTNAME))
>>
>>You do realize that you can get unexpected match if Lastname+Firstname matches some other Lastname?
>>
>>I don't think Index like that can be created in VFP 9 because of variable size of the index
>>It should be
>>UPPER(LASTNAME) + UPPER(FIRSTNAME)
>>* and WHERE clause
>>UPPER(LASTNAME) + UPPER(FIRSTNAME) = UPPER(PADR(m.LASTNAME, LEN(LASTNAME))) + UPPER(PADR(m.FIRSTNAME,LEN(FIRSTNAME)))
>>
>
>Well, I changed the tag to PADR(UPPER(LASTNAME),25)+PADR(UPPER(FIRSTNAME),25), but it makes no change vis a vis the combobox not working, which is my original problem

Have you verified that cursor CountIt has any records? If not, a BROWSE after the SELECT in your code may help you.
Previous
Reply
Map
View

Click here to load this message in the networking platform