vfp之ca(国外英文资料).docVIP

vfp之ca Start CursorAdapter Start CursorAdapter Author: Dung Hennig Translator: fbilo The CursorAdapter class is one of the most important new features in VFP 8, because it provides a simple, easy-to-use interface for accessing remote data sources. In this months article, Dung Hennig will show you the CursorAdapter and how it works. Next month, we will learn some advanced usage. Body: More and more VFP programmers are starting to store their data in data warehouses other than VFP tables like SQL Server or Oracle. There are many reasons lead to this situation, including the vulnerability of VFP table (whether imaginary or so), security, database capacity, as well as the standard of generality and so on. MicroSoft has been making access in each version of VFP Data is more simple, in order to encourage the ethos, it even in VFP 7 CD comes with MSDE (MicroSoft Data Engine, a free, SQL Server paperback edition). However, accessing a backend database is never more cumbersome than using a VFP table, and the mechanisms you can use are daunting: The remote view, which is based on the ODBC connection; SQL Passthrough (SPT) functions, such as SQLCONNECT (), SQLEXEC (), and SQLDISCONNECT (), which are also based on ODBC connections; The ActiveX Data Objects, or ADO, provides a way of accessing object access to an OLE Provider for a variety of database engines; By XML, its a lightweight, platform-independent data transfer mechanism. If youve ever worked on these mechanisms, one thing you might have noticed is that each of them is different. In that case, you must learn to come one by one, but also to an existing application from a mechanism to another, this is not a simple job. With a new base class CursorAdapter, accessing remote data in VFP 8 is much simpler than in the previous version. In my opinion, CursorAdapter is one of the most important new features of VFP 8. I think the best thing about it is: Its easy to use ODBC, ADO, and XML, and youre not familiar with these techno