Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Views vs cursoradapters
Message
From
15/06/2015 13:28:29
 
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows Server 2012
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Web
Miscellaneous
Thread ID:
01621008
Message ID:
01621012
Views:
91
>Hi,
>
>I haven't worked with Foxpro for years and I'm presented with an programming issue. I'm not if because I have just been using other tech for so long that I have forgotten how to think in Foxpro or there are real reasons to use a cursoradapter.
>
>So the question is:
>
>If you are only required to work with one data source such as sqlserver (I realize cursoradapters can access other data sources). Is there an advantage to using cursoradapters over just creating a standard sqlserver view? The sqlserver views are update-able.
>
>Johnf

Thomas makes a good case for cursor adapters,
However, if your SQL Server data will be used in other applications (e.g.Crystal Reports or SSRS) outside of VFP, the SQL Server views are very handy.
Anyone who does not go overboard- deserves to.
Malcolm Forbes, Sr.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform