SET FILTER... problem 1

[torturedmind]

hello people. i have this small question about SET FILTER. i have a free table placed in a form's dataenvironment. this table contains several records and the records are group by a field grp_id and is not indexed. in the form's INIT method i have the following:

lparameters grp_filter

select opdstat
set filter to grp_id = iif(parameters() = 0, 1, grp_filter)
go top

then in vfp6's command window, i call the form

do form myform.scx
do form myform.scx with 1

in the first DO FORM command, the SET FILTER kicks in with no problem. but in the second, all records were displayed regardless of grp_id. what gives?

thanks in advanced.

kilroy
philippines

"Once a king, always a king. But being a knight is more than enough."

 

[torturedmind]

thanks sir mike (wow, there sure are lots of mikes here) #3 tip did the trick. and thanks for the advice. i'll keep 'em all in mind. peace!

kilroy
philippines

"Once a king, always a king. But being a knight is more than enough."

 

[Olaf Doschke]

just a slight change:

LPARAMETERS m.tnGrp_Filter
LOCAL m.lcFilter

m.lcFilter = "GRP_ID="+IIF(Vartype(m.tnGrp_Filter)#"N","1",TRANSFORM(m.tnGrp_Filter))

SET FILTER TO &lcFilter.
LOCATE

Bye, Olaf.