Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Combo box still not Combo'ing
Message
From
27/03/2019 13:38:44
 
 
To
27/03/2019 13:23:48
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
01667365
Message ID:
01667600
Views:
43
>>>>>Hi Dorris.
>>>>>
>>>>>Call the Requery method of the combobox to force it to refresh its list.
>>>>>
>>>>>Doug
>>>>
>>>>Already tried that, no change. But now here's the kicker. If I pull just the firstname, lastname and cboSelectPerson (the combobox) fields off the form to a separate form (running the same code), it works.
>>>>
>>>>On the Original form I've tried:
>>>>Requery - no change
>>>>setting the RowSource to '' before setting everything - no change.
>>>>changing the name of the combobox - no change
>>>>
>>>>I've walked the code and watched the underlying cursor get populated, so I know there are data to go into the silly thing
>>>>
>>>>I've got a combobox acting like there's an empty cursor behind it. click on the down arrow and nothing happens
>>>
>>>Did you check for any conflicts in identifier names? (i.e. make sure you don't have conflicts in names of alias, field names, variables, tag names, etc.)
>>>For example, you might want to make sure that you don't have a table included into the project that has the same name as the cursor.
>>
>>nope, no reused names or tables. Just tried to replace the cbo with a grid and I'm seeing the same behavior. Code runs just fine, nothing shows
>>
>>At this point, I'm just trying to find something that will allow users to select a specific person, short of just browsing the cursor
>
>I repeat my recommendation to change the select statement itself, see my earlier reply. Your Where condition is "dangerous", I don't understand why you stick to it.

ok, I'm not understanding what is 'dangerous' of

WHERE Padr(Upper(Lastname),25)+ Padr(Upper(Firstname),25) = Padr(Upper(lname),25) + Padr(Upper(fname),25)
and !Inactive
"You don't manage people. You manage things - people you lead" Adm. Grace Hopper
Pflugerville, between a Rock and a Weird Place
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform