create sql view MYVIEW remote connection MYCONNECTION as;
select * from employee where last = ?v_last

private v_last
v_last = 'SMITH'
use MY_VIEW

If you use the parameter with ?v_last then VFP will ask you the value on-the-fly if the variable v_last is not defined when you opened the view (this is useful in a development enviroment). If you use the parameter v_last (without the question mark) then VFP will generate an error if the parameter is not defined.


>Hi,
>
>
> anybody can give me an example code of calling a view with a parameters.. for my filter
>
>or should i create a public variable for "example" in filter e.g. i will input nvar in example of view?
>
>TIA.......