?Sequential Fetch Mode? + DevExpress Grid PROBLEM.
Posted: Fri 08 May 2009 14:36
Dear Devart Suppot Team, we have some problems ?Sequential Fetch Mode? used with DevExpress Grid.
We want: "When client needs to fetch more records (for example, user scrolls a grid), another request to server is performed."
We use Devart 5.0.1.0 with DevExpress Grid v8.3.
we want to use ?Sequential Fetch Mode?, so we done everything as described in documentation. We created a typed dataset and a tables in it. We set tables properties in order to use ?Sequential Fetch Mode?.
dataset1.table1.FetchAll = false;//by default
dataset1.table1.QueryRecordCount = true;
dataset1.table1.MaxRecords = 0; //by default
I do:
calling dataset1.table1.active = true;
I see:
1) dataset1.table1.RecordCount = 1383
dataset1.table1.Rows.Count = 1103
2) The sql text (SelectCommand.CommandText) of this table executed in SQLNavigator returns 1383 rows.
Question 1 : why so many records retrieved at once in the beginning? It slows down the functionality very much =(
In another example
I do:
calling dataset1.table2.active = true;
I see:
1) dataset1.table1.RecordCount = 1478
2) dataset1.table1.Rows.Count = 1478
Question 2: why all records are fetched??? All records are fetched!
I do:
calling dataset1.table1.active = true;
I?m on the first record. Grid shows the number of records 1383 (Rows.Count = 1103 RecordCount = 1383). I start scrolling through the records in the grid. When I reach record number 1280 the grid shows that the number of records is 1381 (Rows.Count = 1381 RecordCount = 1381). That? it. I see only 1381 record in the grid. But really there are 1383 records should be.
Question 3: Why it finally shows wrong number of records.
I do:
calling dataset1.table1.active = true;
I?m on the first record. Grid shows the number of records 1383 (Rows.Count = 1103 RecordCount = 1383). I open the filter (the pop up list of all values of some column). As far as I understand now all records should be fetched by the grid in order to form distinct list of values of this column. What I see after this action is Rows.Count = 1381 RecordCount = 1381. Again the same problem as in the previous example.
Question 4: Why it finally shows wrong number of records.
Is there some special things that I should check?
________
Lenders Mortgage Insurance Advice
We want: "When client needs to fetch more records (for example, user scrolls a grid), another request to server is performed."
We use Devart 5.0.1.0 with DevExpress Grid v8.3.
we want to use ?Sequential Fetch Mode?, so we done everything as described in documentation. We created a typed dataset and a tables in it. We set tables properties in order to use ?Sequential Fetch Mode?.
dataset1.table1.FetchAll = false;//by default
dataset1.table1.QueryRecordCount = true;
dataset1.table1.MaxRecords = 0; //by default
I do:
calling dataset1.table1.active = true;
I see:
1) dataset1.table1.RecordCount = 1383
dataset1.table1.Rows.Count = 1103
2) The sql text (SelectCommand.CommandText) of this table executed in SQLNavigator returns 1383 rows.
Question 1 : why so many records retrieved at once in the beginning? It slows down the functionality very much =(
In another example
I do:
calling dataset1.table2.active = true;
I see:
1) dataset1.table1.RecordCount = 1478
2) dataset1.table1.Rows.Count = 1478
Question 2: why all records are fetched??? All records are fetched!
I do:
calling dataset1.table1.active = true;
I?m on the first record. Grid shows the number of records 1383 (Rows.Count = 1103 RecordCount = 1383). I start scrolling through the records in the grid. When I reach record number 1280 the grid shows that the number of records is 1381 (Rows.Count = 1381 RecordCount = 1381). That? it. I see only 1381 record in the grid. But really there are 1383 records should be.
Question 3: Why it finally shows wrong number of records.
I do:
calling dataset1.table1.active = true;
I?m on the first record. Grid shows the number of records 1383 (Rows.Count = 1103 RecordCount = 1383). I open the filter (the pop up list of all values of some column). As far as I understand now all records should be fetched by the grid in order to form distinct list of values of this column. What I see after this action is Rows.Count = 1381 RecordCount = 1381. Again the same problem as in the previous example.
Question 4: Why it finally shows wrong number of records.
Is there some special things that I should check?
________
Lenders Mortgage Insurance Advice