Hello,

I have some trouble on deleting a single record
using a VC++ wizard generated CRecordSet-derived class like
in the example below (exception handling omitted).

rs.Open() works perfect and returns - as expected - a single record.
But on calling rs.Delete() I get an exception
"ORA-00936 Missing expression".

The exception is thrown whenever the AFX_ODBC_CALL
executes the CRecordset generated command like

"DELETE FROM uid.tablename WHERE CURRENT OF CURSOR_xxx"


BTW:
CRecordset::Edit() + CRecordset::Update() throws this exception as well - while CRecordset::AddNew() + CRecordset::Update() does not.
Queries also work.


I guess this could be a problem with the environment.
(ODBC driver (Oracle 8.01.05.00), MDAC 2.6, WinNT4.0SP6, VC++6.0 )

Hope somebody has an idea !?
Regards
Frank

***********************************
MyRecordSet rs(m_pDB);

rs.m_strFilter.Format(_T("ID = %d"), iID);
rs.Open();

if(rs.IsOpen())
{

if ( !rs.IsDeleted() )
{
rs.Delete();
}
rs.Close();
}
************************************