Recently, a database application is developed using the MFC ODBC class, because never used MFC ODBC Class. He has a lot of spirit. And in the 9CBS and other communities also see a lot of novices in the question related questions, but also forget your solve the trouble. So find a place to write down for inquiry. 1, CDATABASE CLASS and CRECORDSET CLASS can be used directly without derived new class2, it is best to declare a cDatabase port directly to manually open the database directly, do not use CRecordSet3 to open the Dynamic Truster Library when using CDATABASET3. Because this shields some of the functions driven by the corresponding database. After loading Usecursorlib, you will have no way to use the dynamic dataset (Snapshot). The static dataset will reduce a lot of efficiency when data is recorded, because the static dataset intends to maintain a static image of a data. The data set returned by the query will be an image with the temporary data. The amount recorded is large, and the efficiency will decrease.
