Information générale
Catégorie:
Codage, syntaxe et commandes
>>>Hello.
>>>Lets say I have a SET FILTER TO... statement such as
>>>
>>>SELECT client
>>>SET FILTER TO Id = 5321 and SSN = "333224444" and status = "OUT" and IIF(INLIST(state, "AZ", "TN", "WI", "TX", "KY", "FL"), unit+DTOS(dob), "!" + Space(10)) != "!"
>>>
>>>I'm new to VFP. But, I don't know anyone who would write something like this. But I found this line in one of our PRGs.
>>>I think this is slowing our calculation process.
>>>
>>>All the fields are indexed except for STATUS and STATE.
>>>What I want to know is will indexing STATUS and STATE fields help speed this up?
>>
>>
>>If the only values of Status are "IN" and "OUT", an index probably won't help, though you could try.
>>
>>Tamar
>
>No. There are several...I think 8 possible values.
Then a tag will help.
Tamar
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement