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