Hi geoff,

Unfortunately that is the way it is. I've been asking for this feature a few years now, but up till VFP9 it is not implemented.

Walter,

Hi
>
>I have a parameterised local view that enables me to decide what records I want to view at runtime.
>
>

>CREATE SQL VIEW V_STATUSMON AS ;
>SELECT Invcont.*, ;
>	FROM wots!invcont ;
>	WHERE &?lcWhere ;
>	ORDER BY lastaction, Custstreet, Custflatnum, our_ref
>

>This enables me to search on any combination of fields I choose, which is really neat and I can do the same thing with the order if I choose.
>
>Unfortuantely when I create as a remote view I get an error when I try to use it.
>
>Does anyone know why or of another way to do the same thing with remote views?
>
>Regards
>Geoff SCott