From Forum Nokia Wiki

Stomo73 11:12, 18 October 2007 (UTC)

// we have autoincrement in index so it should be unique
// but just to make sure, we use 'while', instead of 'if' while(Myview.AtRow())            

This is a bad habbit, I think. Use _ASSERT_DEBUG, if you're suspicious about the query result. But in your example, using 'while' suggests existing fatal error in the DBMS.

"TFileName QueryBuffer;" in DeleteFromDatabaseL().

Do you know any restriction on the length of the SQL statement? If not, do not use TFileName for that. Use TBuf<> if the statement is small (<256byte) or HBufC* if bigger.