StrataFrame Forum » StrataFrame Application Framework - V1 » Business Objects and Data Access (How do I?) » How do I use CopyDataFrom to remove duplicates from BO populated by Browse Dialog?

How do I use CopyDataFrom to remove duplicates from BO populated by Browse Dialog?

Marcia G Akins — Wed, 22 Oct 2008 09:12:33 GMT

Hi All.

I created a view that is a three table join so that I can use this view to populate my BO using the BrowseDialog. The problem is that this may result in multiple records in the BO that gets populated. I do not want the "real" BO being handled in my form to contain these mutliple records. So how can I use CopyDataFrom to ensure that I get only the DISTINCT records for my "real" BO?

TIA.

Marcia

RE: How do I use CopyDataFrom to remove duplicates from BO populated by Browse Dialog?

Trent L. Taylor — Wed, 22 Oct 2008 09:12:33 GMT

Good answer, Paul. :)

RE: How do I use CopyDataFrom to remove duplicates from BO populated by Browse Dialog?

Ivan George Borges — Tue, 21 Oct 2008 18:15:52 GMT

Yep, that was a lot eaiser! :w00t:

RE: How do I use CopyDataFrom to remove duplicates from BO populated by Browse Dialog?

Paul Chase — Tue, 21 Oct 2008 16:25:34 GMT

Marcia

I'm glad I was able to help!! ;)

Paul

RE: How do I use CopyDataFrom to remove duplicates from BO populated by Browse Dialog?

Marcia G Akins — Tue, 21 Oct 2008 15:56:23 GMT

Hi Paul.

I just wanted to thank you so much for your great advice. Once you explained how this worked, everything worked out great.

Thanks again for staying with a newbie like me :)

RE: How do I use CopyDataFrom to remove duplicates from BO populated by Browse Dialog?

Marcia G Akins — Tue, 21 Oct 2008 15:41:46 GMT

[quote][b]Paul Chase (10/21/2008)[/b][hr]

It works like Select Distinct ColumnName(s) fromTableName.

[/quote]

Perfect - thanks for the explanation :) Now I know why my code was blowing up with a "column active_flg does not belong to table client" :D

RE: How do I use CopyDataFrom to remove duplicates from BO populated by Browse Dialog?

Paul Chase — Tue, 21 Oct 2008 15:15:53 GMT

[quote]Thanks - that does help. Now, if I use that syntax (converted to C#, of course ;)), will it use that column to determin which ones are the duplicates but copy all the other columns?[/quote]

Hiya Marcia

It works like Select Distinct ColumnName(s) fromTableName.

You will need to add the columns just as you would with a regular select distinct statement

So something like

Me.RealBizObject.CopyDataFrom(Me.BrowseBizobject.CurrentDataTable.DefaultView.ToTable(
True, New String() {"Cus_pk","cus_Name","Cus_anotherfld"}), MicroFour.StrataFrame.Business.BusinessCloneDataType.ClearAndFillFromCompleteTable)

Select Distinct cus_pk,cus_name,Cus_anotherfld from sometable.

RE: How do I use CopyDataFrom to remove duplicates from BO populated by Browse Dialog?

Marcia G Akins — Tue, 21 Oct 2008 13:48:40 GMT

[quote][b]Paul Chase (10/21/2008)[/b][hr]Hi Marcia,

You can do something like this to copy only distinct rows from one bo to another.

Me.RealBizObject.CopyDataFrom(Me.BrowseBizobject.CurrentDataTable.DefaultView.ToTable(True, New String() {"DistictColumn-ColumnName"}), MicroFour.StrataFrame.Business.BusinessCloneDataType.ClearAndFillFromCompleteTable)

Hope that helps

[/quote]

Hi Paul.

Thanks - that does help. Now, if I use that syntax (converted to C#, of course ;)), will it use that column to determin which ones are the duplicates but copy all the other columns?

RE: How do I use CopyDataFrom to remove duplicates from BO populated by Browse Dialog?

Paul Chase — Tue, 21 Oct 2008 13:01:32 GMT

Hi Marcia,

You can do something like this to copy only distinct rows from one bo to another.

Hope that helps

Paul

RE: How do I use CopyDataFrom to remove duplicates from BO populated by Browse Dialog?

Marcia G Akins — Tue, 21 Oct 2008 10:15:13 GMT

[quote][b]Ivan George Borges (10/21/2008)[/b][hr]Hi Marcia.

As for how to filter the duplicated records, you could add a new Column to your BO for that purpose.

[codesnippet]

    Private Sub MyBO_CurrentDataTableInitialized() Handles MyBO.CurrentDataTableInitialized
        If Me.CurrentDataTable.Columns.Contains("myb_Duplicated") = False Then
            Me.CurrentDataTable.Columns.Add("myb_Duplicated", System.Type.GetType("System.Boolean"))
        End If
    End Sub

[/codesnippet]

(You probably need to create the custom property for that column too)

Then you could go through all your records testing for duplicated ones, and flaging then as so. Filter on that flag before the CopyDataFrom.

Hope I could make some sense... ;)[/quote]

Hi Ivan.

Thanks so much for the quick response. I wish I could say that this makes sense to me, but unfortunately, it doesn't :)

I have used the CopyDataFrom method before when there was no chance of pulling back duplicate records. Basically, I am after a way to do a "SELECT DISTINCT" from the BrowseDialog BO into the "real" BO.

RE: How do I use CopyDataFrom to remove duplicates from BO populated by Browse Dialog?

Ivan George Borges — Tue, 21 Oct 2008 09:56:58 GMT

Hi Marcia.

Maybe you could drop another instance of your BO in your form and use it as your BrowseDialog's BusinessObjectToPopulate. Then in the BrowseDialogClosed method, if a OK was pressed by the user, you could filter your populated BO as needed and use the CopyDataFrom to copy the records to your primary BO.

As for how to filter the duplicated records, you could add a new Column to your BO for that purpose.

[codesnippet]

[/codesnippet]

(You probably need to create the custom property for that column too)

Then you could go through all your records testing for duplicated ones, and flaging then as so. Filter on that flag before the CopyDataFrom.

Hope I could make some sense... ;)