>VFP 5.0
>set deleted on
>
>select sum(myvalue) from mytable : works fine
>select max(myvalue) from mytable : deleted records aren't filtered out : why not ? Try it out !
Pascal,
Works right in VFP5.0. 2 things I can think of :
1) There is another value same as deleted one and not deleted.
2) set deleted is off for session (scoped to current session)
Cetin