Hi Walter
Sorry to bother you at this late stage but I am trying to do this remote view with macro substitution in VFP9 and am getting errors. Was it dropped from the final release or is there some specific syntax I need to use.
Regards
Geoff Scott
>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
May all your weeds be wildflowers