This bit a code might help...
CDatabase db;
CString strSQL;
// Open the database with its DSN Name.
db.OpenEx( _T( "DSN=HWULogData" ),
CDatabase::noOdbcDialog );
//Build the SQLQuery
strSQL = _T("DELETE FROM [MissionData]...
Are you using the keyword Between alone?<br>A correct syntax might be :<br>SELECT * <br>FROM TblTest<br>WHERE FieldA BETWEEN " + lngFldA + " AND " + AnotherLng + ";<br><br>for example<br><br>ZIL
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.