General information
Category:
Coding, syntax & commands
>>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.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only