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

Move methods and filtering

Tim Dol — Fri, 09 May 2008 09:20:49 GMT

I'm not sure if I'm doing something wrong or discovered a small bug.

I have two related business objects on a form, Tasks and TaskPredecessors. I'm using 'MatchCurrentRow' on the ChildFilterRowMethod.

I am executing a routine to populate the 'Tasks' BO based on data from a temporary business object. Basically iterating through the temporary BO and creating new rows in the 'Tasks' BO. This works fine.

Once this routine has completed, I need to populate the 'TaskPredecessors' based on information in the Tasks BO. Basically I am creating dependencies between the tasks.

I am using a similar approach of iterating the Tasks BO...If MoveFirst... MoveNext.. and creating new rows in the TaskPrecedessors BO, however I am getting an error on the NewRow (Index 0 is either negative or above rows count).

I discovered that the Tasks filter property isn't changing as I iterate through the BO. The property holds the value of the last row from the initial population.

Should the Move methods be changing the filter property according to the parent primary key?

Thanks,

Tim

RE: Move methods and filtering

Trent L. Taylor — Fri, 09 May 2008 09:20:49 GMT

[codesnippet] have two related business objects on a form, Tasks and TaskPredecessors. I'm using 'MatchCurrentRow' on the ChildFilterRowMethod.[/codesnippet]

Hey, Tim. A couple of things here. I will see if I can reproduce as I don't think there is an issue here...so there could be something funny with the relationship or something long those lines.

However, I would try something and change one of your processes. You can definitely use the Move methods...I still have code that uses them, but you might want to start using the GetEnumerable() method on the BO:

[codesnippet]For Each bo As CustomersBO In MyCustomers.GetEnumerable()
'-- You can then reference each row strong typed via the bo instance
If bo.cust_LastName.Equals("SomeValue") Then
'-- Do something else
End If
Next[/codesnippet]

This method takes care of a lot of things for you such as saving off and restoring the current row index, etc. Plus...it is faster, not massively, but every little bit counts :)

Next, manually set the filter on the child to see if your issue is resolved. This is generally what I do anyway because I end up leaving the AutoFitler on half the time and end up chasing my tail later when I add a new record and things get funky on me :)

[codesnippet]MyChildBo.Filter = "MyChildField = " & MyParentBO.FilterValueField

'-- Place your for loop or Move code here

'-- Don't forget to reset the filter

MyChildBo.Filter = ""[/codesnippet]

Try that and see if your problem goes away. It will at least be a good starting point.

RE: Move methods and filtering

Tim Dol — Fri, 09 May 2008 08:25:15 GMT

I fully understand the parent / child concept. The problem is the child records are not filtering correctly as I 'move' through the parent records.

RE: Move methods and filtering

Peter Denton — Thu, 08 May 2008 18:53:55 GMT

G'day

I believe that you may be missing the point of the parent child relationship between BOs (as I certainly did when I first started using them). If you have the parent child relationship set up in the child BO, you don't have to populate the child BO based on what you have just populated the parent BO with, you just populate it with everything and strataframe takes care of the filtering.

Peter