>Has anyone had this problem in VFP 7 and if so how do I get around it. When I create a Parameterized Remote View and try to save it I get an error "Base table fields have been changed and no longer match view fields. View field properties cannot be set.", then if I click ok and try to save it again all is fine. Now I can execute the view and it prompts me for the field data that the view is set for.
Yes, I have seen this
If you use more than one join ( internal, or outer), VFP create wrong code
for it
See SQL in view designer
It will be
join table ..
join tatable1 ...
..
on ...
on ...
But VFP undestand only different standard
join table ...
on
join table1
on
So, what I do myself
I take VFP code from view designer
Change it ( change places of join and on)
Create view programatically and it works
Sure, if to open it again in view designer and save , VFP again will make it wrong for itself
It is better to use where instead of joins for parameters views, if it is possible.
It is described in FAQ and 2 years ago I published small paper on www.vfug.org in newsletters
Best whishes, Vladimir