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
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)