StrataFrame Forum » StrataFrame Application Framework - V1 » Business Objects and Data Access (How do I?) » Access To Deleted Rows in Business Object

Access To Deleted Rows in Business Object

Tim Dol — Wed, 03 Oct 2007 09:27:25 GMT

Do you keep a list of deleted rows within the business object? I found I can check the row state in CurrentDataTable.Rows but I can't locate the data.

Thanks,
Tim

RE: Access To Deleted Rows in Business Object

StrataFrame Team — Wed, 03 Oct 2007 09:27:25 GMT

You can access the data by either using the CurrentRow.Item("FieldName", rowVersion) and pass Original as the row version or you can go to the BOMapper and for each field on the business object you want to access, customize it and check the Allow Deleted Rows option, which will test on the row state and return the original value if the row is deleted.

RE: Access To Deleted Rows in Business Object

Tim Dol — Wed, 03 Oct 2007 07:50:37 GMT

In my example I deleted two rows. I can see the CurrentDataTable row count value, which is correct, but I can't get at the data. I get an error accessing the row item 'Deleted Row Information Cannot be accessed through the row'.

Here is a sample of my code. Am I accessing the row item information correctly?

Thanks

Tim

Dim loRow As DataRow

'-- Cycle through the DataTable Rows

For Each loRow In Me.CurrentDataTable.Rows

If loRow.RowState = DataRowState.Added Or loRow.RowState = DataRowState.Deleted Then

dn.FillByPrimaryKey(loRow.Item("wpt_DepartmentCode"), loRow.Item("wpt_CategoryCode"))

If dn.Count > 0 Then

RE: Access To Deleted Rows in Business Object

Trent L. Taylor — Tue, 02 Oct 2007 20:37:29 GMT

They are in there unless you have cleared the BO. By default they are filtered out and not displayed. You can cycle through the CurrentDataTable or set the ShowDeletedRows on the BO property to True.