Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Combo box not Combo'ing
Message
 
 
À
15/03/2019 16:08:17
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Divers
Thread ID:
01667274
Message ID:
01667285
Vues:
57
>>>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)))
--sb--
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform