Hi jl3574,
Just looking at your post while searching for an answer...
theRec->Open(AFX_DB_USE_DEFAULT_TYPE,"select STYLE_ID from STYLES",CRecordset::readOnly);
//Tablename is STYLE_ID, column name is STYLES
Looks like your backwards in your SELECT statement...the FROM clause...
Hi,
A visual C++ 6.0 app, ODBC, using a SELECT statement in a CRecordset::Open() statement as follows:
CString strCmd;
strCmd = "SELECT [102_3_FenetreDeSortie] FROM [Amenagements Exterieurs] WHERE [102_3_FenetreDeSortie] LIKE '+*'";//
//create an instance of the recordset...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.