No idea what is going on, really. Of course, you may want to check that the SQL command works when you type it into the command window (or use it in a program) directly, and make sure that you are really macro-substituting exactly the same command.

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