COView Overview

class COView : public CPureBase

        OLEDB view is a special object which can be referred to the section MSDN/Platform SDK/Data Service/Microsoft® Data Access Components (MDAC) SDK/Microsoft OLEDB/OLE DB/OLE DB Programmer's Reference/Introduction to OLEDB/Chapter 4: Rowset. It enables an OLEDB provider to expose simple operations such as sorting or filtering a rowset without supporting full SQL command statement.

        Currently, most of OLEDB providers don't support the OLEDB view object, but MS Client Cursor Engine (CCE) does. Use of MS CCE can reduce data movement over network and is beneficial to a listview. For example, we want to fill a listview with thousands of records and enable the obtained records sorted according to the column clicked. The common way is to send a query to a server data source, sort records at the server side and fetch records to the client once a column of a listview is clicked. Obviously, it has a drawback. The better way is to retrieve all the obtained records to a client one time and sort them at the client side once required. MS CCE does provide this service, and many more.

        COView is provided to make use of MS CCE view object easier. For how to use it, see example FilterSort.