>>I have two ways that I could use to set a filter in a table in a form's dataenvironment.
>>I'd greatly appreciate some comment or suggestions about which way is best or any alternatives
>>
>>1.. (The old way?)
>>oldSel= SELECT()
>>SELECT MyAlias
>>SET FILTER TO myExpression
>>SELECT (m.oldSel)
>>
>>2.. (Using the DE)
>>oCursor= GetCursor(THISFORM, "myalias") && GetCursor defined below
>>oCursor.filter= "myExpression"
>>
>>An interesting difference between 1 and 2 is that 2 moves the record pointer back to the first matching record. SET FILTER never moves the record pointer at all.
>>
>>

Function GetCursor
>>* returns a cursor object from the dataenvironment of the given form and alias
>>LPARAMETER oFrm, ;		&& the form
>>	cAlias				&& the alias we are looking for
>>LOCAL ARRAY a_Obj[1]
>>LOCAL cObj, oObj
>>* get array of object names in dataenvironment
>>AMEMBERS(a_Obj, m.oFrm.Dataenvironment, 2)
>>FOR EACH cObj IN a_Obj
>>	oObj= EVALUATE("m.oFrm.Dataenvironment."+ m.cObj)
>>	IF m.oObj.BaseClass = "Cursor" ;
>>			AND UPPER(m.oObj.Alias) = UPPER(m.cAlias)
>>		* found it
>>		RETURN m.oObj
>>		*<<<<<<<<<<<
>>	ENDIF
>>ENDFOR
>>RETURN .NULL.
>>

>

>Why not use a parametized view and pass a parm to the form that is used by the view?
>
>Robert

Could do that - but I'm not clear on how to change the parameter while the form is active based on a user selection. How do you requery the view?