Dear Tim!

I have to ask You another question, because I can't to solve this problem by myself with reading manuals and forum.
The problem is that in some cases after apply a filter grid shows records, that are  don't satisfy filter condition. these records are shown, but it impossible to navigate them by clicking, only by scrolling with scrollbar.
The case I mean it's when grid is grouping by one of the columns. I use devexpress grid. With Absolute Database, which I try to replace with ElevateDb, after filtering  groupped table records shown properly. So I think, that it is not devexpress peculiarity. If table not groupped then all ok.

What it can be and how set up table, engine, session or filter so, that table shows only recors, that are satisfy filter condition?

Regards,
Andrews

Andrews,

<< I have to ask You another question, because I can't to solve this problem
by myself with reading manuals and forum.
The problem is that in some cases after apply a filter grid shows records,
that are  don't satisfy filter condition. these records are shown, but it
impossible to navigate them by clicking, only by scrolling with scrollbar.
The case I mean it's when grid is grouping by one of the columns. I use
devexpress grid. With Absolute Database, which I try to replace with
ElevateDb, after filtering  groupped table records shown properly. So I
think, that it is not devexpress peculiarity. If table not groupped then all
ok. >>

So you're seeing issues with the DevExpress grid when grouping using the
DevExpress grid ?  If that's the case, then the issue is really something
that DevExpress should look at, since my understanding is that grouping in
their grid requires that the grid load all of the rows into the grid first.
In other words, when the grouping occurs, ElevateDB isn't even involved
anymore.

--
Tim Young
Elevate Software
www.elevatesoft.com