Hi geoff,

I did already reply you in another thread. But anyways, no AFAIK it is not supported for remote views. I shame really. I don't understand why because honestly I don't see any technical restrictions.

The only thing you can do is to use SPT (SQL pass through) and make the result cursor updatable.
However you will lose the advantage of views where you could have an automatic translation from datetime to date fields.

Walter,



>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