>hello all
>
>VFP 7.0 SP1
>
>i have form with many fields and in code i set filter to table based on the some input on the screen like set filt to cc+var+year=thisform.cc.value+thisform.var.value+thisform.year.value , but for some reason this logic doesn't work so i set a breakpoint in the program , after reaching the breakpoint when i switch to data session window to see if the filter is applied i get a status bar message Filter Cleared and it displays blank ,
>
>so how to avoid this.
Don't use an object reference in a filter; the object context can (and in the debugger, does) shift and the filter expression becomes indeterminate. Either use a memvar that remains in scope for the entire life of the filter regardless of the active object, or convert the expression to a literal.