Why should I use SQL statements in VC?

stonelife

I used ODBC to connect three tables created by SQL, and used the following code in MFC
CString strSQL = "SELECT * from Course";
m_pSet-> m_pDatabase-> ExecuteSQL (strSQL);
Found that the ExecuteSQL () function does not return a value, so what can we do with it ???

红旗下de蛋

For example, if you want to insert a record or update a record, what's the use of the return value? The success or failure of execution can be solved with try catch.

stonelife

What should I do if I want to join two tables

lixiaof6471

Generally speaking, VC uses a database, which will not be the main application. Look for a book on database programming.