>>What are the advantages/disadvantages of using a remote view into a SQL database through a .DBC versus creating the view in the database itself?
>>
>>Rick Grinter
>
>A view in the DBC whose source is the SQL tables directly seems better to me in VFP 7 or earlier. I think this is more of a personal preference, than naything. In VFP 8, the CursorAdapter is the cat's meow. How about coming to our next DFW FoxPro User Group meeting next Thursday [Jan 9], and you can ask this question during our open Q & A session. See
http://www.dfwfox.org for location, etc.
Thanks for the invite. Unfortunately I was out of town (as seems to be the story of my life). I haven't played with VFP8 yet but I wonder if there are not speed advantages to storing the view in the SQL database.
Rick