That is what I mean. I do not agree that the SQL Select command is smarter than the IF command. The following command will not call function1 unless field1 = "Test" - with or without an index:
IF field1 = "Test" and function1()
>That's probably what he means.
>
>But in one way the SELECT statement is a little smarter...if there is an index on field1, this code will not call function1() for every record in the table.
>
>
>select * from table1 where function1() and field1 = "Test"
>
>
>>
>>This is what he means, I think:
>>
>>
IF .F. AND DontEval()
>> ? "Don't print"
>>ENDIF
>>
>>FUNCTION DontEval
>> ? "Don't Print"
>>ENDif