John,
SELECT * FROM mytable WHERE myUDF() INTO CURSOR myresult
FUNCTION myUDF()
IF myCondition
lnWrk = SELECT(0)
SELECT myresult
LOCATE FOR condition1
IF FOUND()
ENDIF
SELECT (lnWrk)
ENDIF
RETURN .T.
ENDFUNCVisual FoxPro returns empty record in result cursor for those records which match mtCondition.
Any ideas?
Preface: This is not a good programming technique.
1) *-- Some codes... ???
a) myCondition is USED('myresult') for skip SELECT build structure phase ?
b) condition1 is ???
c) *-- Som something ??? What do you do ?
Try this:
SELECT * FROM mytable HAVING myUDF() INTO CURSOR myresult
FUNCTION myUDF()
SELECT myresult
LOCATE FOR condition1
IF FOUND()
ENDIF
ENDIF
ENDFUNCFabio
