StrataFrame Forum » StrataFrame Application Framework - V1 » Business Objects and Data Access (How do I?) » CurrentRowIndex

CurrentRowIndex

Larry Caylor — Sun, 04 Jan 2009 23:22:02 GMT

When I use the Add() method to add a new row to a BO that has a Sort defined, the CurrentRowIndex is being set to zero rather than the actual index of the new row. If a Filter is added to the BO rather than a sort, the CurrentRowIndex is maintained correctly.

I'm on v1.61 pre-release.

-Larry

RE: CurrentRowIndex

Edhy Rijo — Sun, 04 Jan 2009 23:22:02 GMT

[quote][b]Chan (01/04/2009)[/b][hr]May I know what is the "workaround"?[/quote]

Hi Chan,

I guess it is to reset the filter prior adding then set the filter again, here is a pseudo code:

[codesnippet][code]

DIM strTempFilter as String = MyBO.Filter

MyBO.Filter = String.Empty

MyBO.Add()

MyBO.Filter = strTempFilter

[/code][/codesnippet]

RE: CurrentRowIndex

Chan — Sun, 04 Jan 2009 22:16:30 GMT

Hi,
May I know what is the "workaround"?

Thank you

RE: CurrentRowIndex

Larry Caylor — Tue, 05 Jun 2007 17:35:46 GMT

Thanks for the explanation. It must have been right after lunch when we went over that in class:doze: Conceptually I can see how you could handle a sorted BO since a Sort would never remove a row from the CurrentView, but a Filter would present some issues.

-Larry

RE: CurrentRowIndex

StrataFrame Team — Tue, 05 Jun 2007 13:19:03 GMT

No, we actually try to handle the situations where a new row might be filtered out or sorted, however, the following code is called right before the SetDefaultValues() is raised, so it will be right up until you set a field within the SetDefaultValues(). The problem with having a sort or filter set when you're adding rows is that the record might change each time you set another column on the business object, causing the view to resort or refilter the row.

                '-- Start from the back of the list and cycle through the rows to find the row index
                For lnCnt = Me.Count - 1 To 0 Step -1
                    If _CurrentDataTable.DefaultView(lnCnt).Row Is loRow Then
                        '-- We've found our row index
                        lnRowIndex = lnCnt
                        Exit For
                    End If
                Next

'-- Set the row index to the index of the new row
_CurrentRowIndex = lnRowIndex

RE: CurrentRowIndex

Trent L. Taylor — Tue, 05 Jun 2007 13:17:05 GMT

Yup....if you recall, we actually touched on this briefly during class because I too have been there before. When you add the new record the filter is immediately applied.

RE: CurrentRowIndex

Larry Caylor — Tue, 05 Jun 2007 12:33:30 GMT

After a little more testing I found my original tests were incorrect and that a Filter causes the same behavior as a Sort:blush: I'm assuming that this is probably by design and you can't add rows to sorted or filtered BOs.

-Larry