>>>>>I would like to connect to Microsoft SQL server via vfp50?
>>>>>I have been using power builder 6.5 to connect to Microsoft SQL server, but now I would like to us vfp50 and be able to view and change the data. Does anybody have any ideas?
>>>>
>>>>Hi Robert,
>>>>
>>>>You need to use SQL Server ODBC Driver to connect to SQL Server Database. Create your data source using this driver through Windows Control Panel/ODBC Data Sources.
>>>>
>>>>Nick
>>>I got it, thanks folks - Where do I keep the VIEWS after I close the
>>>connection to the server. I do not want these VIEWS on the user's computer.
>>>Should I delete them, or should I keep them on the server. If I keep
>>>them on the server, will this slow down the retrieval time?
>>
>>Hi Robert,
>>
>>I don't quite understand what you mean. What did you create? a remote view or SQL Pass-Through cursor? In both cases if you retrieved some data to the local PCs, the retrieved recordset is gone anyway after you close your view or cursor.
>>
>>Nick
>Hi Nick:
>I have closed my view and open it again and I can still see the data. I would
>like this data to go away for good. How do I do that?

If you have a remote view, next time you open it it retrieves the same data from the server. If you don't want this data in the back-end database you need to delete the records in the view and send updates to the back-end. Of course your remote view has to be updatable.