Selective load into C1DataViewSet

Last post 01-15-2008 1:24 PM by vbogey. 2 replies.

Page 1 of 1 (3 items)
	Sort Posts: Previous Next

10-24-2007 4:20 PM

vbogey
Joined on 03-09-2006
Posts 26

Selective load into C1DataViewSet

Reply Contact

Here is my simple scenario:

I have 2 tables:

Orders with over 1,000,000 rows and
[Order Details with over 5,000,000 rows

How to load just selective row(s) from Orders and only corresponding rows from [Order Details] table into C1DataViewSet?

vbogey

Filed under: filter, fetch

12-20-2007 3:18 PM In reply to

C1_JohnAd
Joined on 03-03-2006
Posts 658

Re: Selective load into C1DataViewSet

Reply Contact

Hi vbogey,

You can use the RowFilter() property for different views in the C1DataViewSet.

For example: If you wish to implement filter on a button click, you can use the code

in the following manner under Button Click event.

Me.C1DataViewSet1.Views("Orders").RowFilter = "OrderID = 10248"

Since Orders and Order Details will be linked by relation in the ViewSet Designer,

after filtering only corresponding rows from the Order Details will be fetched.

I hope this helps.

Regards,

Allen Smith

<vbogey> wrote in message news:199234@10.0.1.98...

Here is my simple scenario:

I have 2 tables:

Orders with over 1,000,000 rows and
[Order Details with over 5,000,000 rows

How to load just selective row(s) from Orders and only corresponding rows from [Order Details] table into C1DataViewSet?

vbogey

http://helpcentral.componentone.com/cs/forums/p/73389/199234.aspx#199234

01-15-2008 1:24 PM In reply to

vbogey
Joined on 03-09-2006
Posts 26

Re: Selective load into C1DataViewSet

Reply Contact

Almost 1 year later I have found the answer for my question.

Sorry Allen, but I can't confirm your findings.

There are 2 aspects of loading data:

1. Loading data from database into dataset table and as a result into C1DataSetView Table and
2. "Loading" or rather selecting data into C1DataSetView View.

You gave me an answer for the second one.

My original question was about loading selective rows from database.

I don't want to load millions of rows of data when I need only just few.

I'm afraid this issue has been overlooked in the design of this component.

You may test my statement debugging ViewSet_Define_Fill_Update.sln to see that filter set on C1DataSetView.View affects only particular C1DataSetView.View and not underlying C1DataSetView.Table.

Page 1 of 1 (3 items)

C1 Community