This project is read-only.

Delete Rows

Apr 21, 2010 at 6:41 AM

how will i delete some rows of a table at a particular condition.

Nov 3, 2011 at 8:16 PM

Bump this topic to the top.  I am having trouble too.

Nov 4, 2011 at 2:50 PM

Can you guys provide a bit more information of what you exactly want to do? A code snippet would help too.

Thanks.

Nov 4, 2011 at 5:15 PM

Thanks for getting back.  I have marked an object for deletion.  I'm using the Pervasive storage by the way.

this.catalog.context.MarkForDeletion(persistedItem);

This object was retrieved with.. 

persistedItem = objectSet.GetObject("PART = {0} AND LOCATION = {1}", item.PART, item.LOCATION);

After I persist changes and commit, the following test case fails.

Assert.IsNull(objectSet.GetObject("PART = {0} AND LOCATION = {1}", item.PART, item.LOCATION));

The record should be removed from the database and this should be null right?  However, the record still exists in the database.

Feb 4, 2012 at 6:02 AM

This should be the case. Any chance you could debug a bit deeper in the code to see where it fails?