strange behaviour in grid with filtered dataset

[tasnim]

hi everyone

i have a grid, with direction set to right to left, and dataset provider.
my dataset provider attached to a query.
when i open a query, grid adapt very well and show number of rows according to my browser height and when i change browser size it adapt well.
but when i filter my dataset and reload grid (ajaxrerender also checked) it show total page number correctly (for example 3 page).
in first page half of the time show full list of record and half of the time it show record to 1/2 of grid and second part of grid is remain empty
when i navigate to second ans third page it's always empty.
when i resize browser it always show up to record that is displays in first page.
for example if i resize browser and make it smaller page count change from 3 to 6.
page 1, 2 show records, page 3 some time show record and other page always remain empty.

i also want to thanks, your component is so greate

[Alexander Bulei]

Hi tasnim,

Please, post here the simple testcase project.
TIA

Best Regards.

[tasnim]

Hi Alexander

i try to reproduce it with access as database and ado connection for test case, but it worked fine.
i use nexusdb as database and with it problem always exist.
one thing i discovered is when i change DataseProvider->GotoMethod from dsgtRowNo to dsgtMoveBy there is no problem, but
it become so slow when grid page is more than 500 pages, again when i put it back to dsgtRowNo only 1..4 page has data and other page become blank, column headers are exist, no data, and no cell border line, complete white page,
when changing a page loading... message will be displayed and page number is changed but no data will be show.

thanks

[tasnim]

same behavior with Jqgridoption.scroll = true
when i scroll down to 2 or 3 page it become white

i have a sql query with around 6000 record, and has a autoinc field Named ID as key, in dataset provider i set keyfields to ID (also check with no keyfields)

i checked with simple filter statement as follow:

Code: Select all

Query,Filter := '(ID>1000) AND (ID<3000)';
Query,Filtered := True;

[Jorge Sousa]

Hi tasnim

CGDevTools needs RecNo to operate so you must set dsoRecNoSupport to your Query->Options

DatasetProvider->GotoMethod = dsgtMoveBy, was introduced, precisely to support datasets without RecNo