equal
deleted
inserted
replaced
239 FLOG( _L( "[Provisioning] CWPInternetAPDB::ReadItemsL" ) ); |
239 FLOG( _L( "[Provisioning] CWPInternetAPDB::ReadItemsL" ) ); |
240 RDbView Myview; |
240 RDbView Myview; |
241 Myview.Prepare(iItemsDatabase, TDbQuery(QueryBuffer)); |
241 Myview.Prepare(iItemsDatabase, TDbQuery(QueryBuffer)); |
242 CleanupClosePushL(Myview); |
242 CleanupClosePushL(Myview); |
243 Myview.EvaluateAll(); |
243 Myview.EvaluateAll(); |
244 if ( Myview.FirstL()) |
244 Myview.FirstL(); |
245 { |
245 |
246 while (Myview.AtRow()) |
246 while (Myview.AtRow()) |
247 { |
247 { |
248 Myview.GetL(); |
248 Myview.GetL(); |
249 |
249 |
250 TAccessPointItem AccessPointItem; |
250 TAccessPointItem AccessPointItem; |
251 AccessPointItem.iIndex = Myview.ColInt(1); |
251 AccessPointItem.iIndex = Myview.ColInt(1); |
254 AccessPointItem.iOriginator.Copy(Myview.ColDes(4)); |
254 AccessPointItem.iOriginator.Copy(Myview.ColDes(4)); |
255 |
255 |
256 aItemArray.Append(AccessPointItem); |
256 aItemArray.Append(AccessPointItem); |
257 Myview.NextL(); |
257 Myview.NextL(); |
258 } |
258 } |
259 } |
|
260 |
259 |
261 CleanupStack::PopAndDestroy(); // Myview |
260 CleanupStack::PopAndDestroy(); // Myview |
262 FLOG( _L( "[Provisioning] CWPInternetAPDB::ReadItemsL: done" ) ); |
261 FLOG( _L( "[Provisioning] CWPInternetAPDB::ReadItemsL: done" ) ); |
263 } |
262 } |
264 |
263 |
322 // query buffer with index finds only the selected item row. |
321 // query buffer with index finds only the selected item row. |
323 Myview.Prepare(iItemsDatabase, TDbQuery(QueryBuffer)); |
322 Myview.Prepare(iItemsDatabase, TDbQuery(QueryBuffer)); |
324 CleanupClosePushL(Myview); |
323 CleanupClosePushL(Myview); |
325 |
324 |
326 Myview.EvaluateAll(); |
325 Myview.EvaluateAll(); |
327 if( Myview.FirstL()) |
326 Myview.FirstL(); |
328 { |
327 |
329 if (!Myview.IsEmptyL()) |
328 if (!Myview.IsEmptyL()) |
330 { |
329 { |
331 // we have autoincrement in index so it should be unique |
330 // we have autoincrement in index so it should be unique |
332 // but just to make sure, we use 'while', instead of 'if' |
331 // but just to make sure, we use 'while', instead of 'if' |
333 while (Myview.AtRow()) |
332 while (Myview.AtRow()) |
334 { |
333 { |
340 iItemsDatabase.Commit(); |
339 iItemsDatabase.Commit(); |
341 // compacts the databse, by physically removig deleted data. |
340 // compacts the databse, by physically removig deleted data. |
342 iItemsDatabase.Compact(); |
341 iItemsDatabase.Compact(); |
343 rowsdeleted = ETrue; |
342 rowsdeleted = ETrue; |
344 } |
343 } |
345 } |
|
346 CleanupStack::PopAndDestroy(1); // Myview |
344 CleanupStack::PopAndDestroy(1); // Myview |
347 |
345 |
348 FLOG( _L( "[Provisioning] CWPInternetAPDB::DeleteFromDatabaseL: done" ) ); |
346 FLOG( _L( "[Provisioning] CWPInternetAPDB::DeleteFromDatabaseL: done" ) ); |
349 return rowsdeleted; |
347 return rowsdeleted; |
350 } |
348 } |