MFC -> CDBException

[Diogo Moreno]

hi there...
When try to delete a record, CRecordset throws a
AFX_SQL_ERROR_NO_CURRENT_RECORD exception... Anybody knows what it
means? My sql query is right...

Ex.:
CRecordset m_reg;
m_reg.m_strFilter = "ID_NET=0 AND ID_CASE=107 AND NAME='gr' AND
PT_PTO='Line AC 1 3 1'";
m_reg.Delete(); //exception

TIA!

[Howard]

"Diogo Moreno" <dm***@yahoo.com> wrote in message
news:53**************************@posting.google.c om...

hi there...
When try to delete a record, CRecordset throws a
AFX_SQL_ERROR_NO_CURRENT_RECORD exception... Anybody knows what it
means? My sql query is right...

Ex.:
CRecordset m_reg;
m_reg.m_strFilter = "ID_NET=0 AND ID_CASE=107 AND NAME='gr' AND
PT_PTO='Line AC 1 3 1'";
m_reg.Delete(); //exception

TIA!

Looks like it means that there are no records when that filter is applied.
You may have to put that Delete in a try..except block to catch exceptions
like this. But you'd better ask this in a microsoft newsgroup, preferable
one dealing with sql. It's pretty far off-topic here.
-Howard