Summary of operations on the ACCESS database and summary of the access Database

Summary of operations on the ACCESS database and summary of the access Database

I

CDaoRecordset is DAO and CRecordset is ODBC,

VC ++ 6.0 provides some programming interfaces. There are five main types:
1. odbc api;
2. mfc odbc class;
3. mfc dao class; (Data Access Object)
4. OLE/DB of MFC;

5. ActiveX Data Object (ADO ).

II

Rs. GetFieldValue (0co1); different from rs. GetFieldValue (short) 0, co1;

Because the following functions are overload functions:

Void GetFieldValue (LPCTSTR lpszName, CString & strValue );
Void GetFieldValue (short nIndex, CString & strValue );

3. In access, the condition for like fuzzy query is a like '23 * ', while in the program, a like '000000' is required, that is, the standard SQL syntax.