>Hi all
>I have a problem with filter command. when i use from below command in my form
>
>
> Select Hesab01
> SET FILTER TO GCode = thisform.y_GCode .AND. !EMPTY(KCode) .AND. EMPTY(MCode)
> thisform.list2.ControlSource = "Hesab01"
> thisform.list2.RowSource = "KName"
>
>
>i get not correct filtered records, but if i change it as below
>
>
> Select Hesab01
> filterStr = "SET FILTER TO GCode = " + ALLTRIM(STR(thisform.y_GCode)) + ;
> " .AND. !EMPTY(KCode) .AND. EMPTY(MCode)"
> &FilterStr
>
> thisform.list2.ControlSource = "Hesab01"
> thisform.list2.RowSource = "KName"
>
>
>my list2 filled with right records. i know it is because of GCode = thisform.y_GCode , but why it is wrong?
>thanks for your help
If thisform.y_gcode is not fixed then you may really get unpredictable results.
Btw, are you sure that you don't confuse Controlsource and Rowsource in your code. Also, using SET FILTER is a bad practice; if possible, it should be avoided.
Edward Pikman
Independent Consultant