You can do that now but with Local Views. Look at the OpenViews property of the data environment of the form. Just switch it between local and remote. It's easy and you can use all the power of VFP files.
>It's a long story - but in a nutshell it's so I can switch backend databases. I change the connection string for SQL server or for VFP tables - so I'm able to use the same remote views. I know it sounds weird but it's worked for me pretty well. Obviously the tables have to be designed properly - but with a little planning it's pretty slick.
>
>
>>Why do you have a remote view to a VFP table?
>>
>>>I have a remote view that connects to a VFP table (yes I know that seems odd).
>>>
>>>My problem is that the remote view is excluding the deleted records - which in an ideal world would be fine - however in my case I'd actually like to see them. I tried the old SET DELETED ON and SET DELETED OFF thing - but same results.
>>>
>>>So is there anyway for me to see the deleted records in the remote view?
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer