WOW, now that's thinking big. Unfortunately,

lcSQL=[SELECT * FROM CUSTSTATUS]
CREATE SQL VIEW V_test AS ;
&?lcSQL

gives me a

SQL SELECT statement is invalid

in VFP7. VFP8 give a different error.

CREATE SQL VIEW V_test AS ;
SELECT * FROM CUSTSTATUS

works fine. Didn't get as far as a remote view.

thanks anyway.
Geoff Scott

>How about macro-substituting the entire command?
>
>

>MyCommand = "Create sql view..."
>&MyCommand

>
>>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