Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Combo box still not Combo'ing
Message
From
27/03/2019 14:12:01
 
 
To
27/03/2019 13:38:44
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
01667365
Message ID:
01667604
Views:
42
>>>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

Now you have changed the expression from the one I originally answered to. Anyway, it's a "stupid" expression in my mind. What's wrong with
Where Upper(Lastname) = Upper(lname) and Upper(Firstname) = Upper(fname) and !Inactive?
Just make sure that the lengths of the compared strings are equal.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform