Hi

I have update , now , EDB from 2.03 B5 to 2.03 B7

and i have a strange big problem.

i have a tabled RANGED in standard Delphi dbgrid.

press :

1)  Insert key   ( new row appear )
2) Enter "xxx" value in any field
3) press "Return" key

when press Return key , the new row record disappear ^^"

if i retry 5 times this operation , i can't see these 5 records in my
dbgrid.

But this record are present in Table ( i can see these with edb Manger )

if i close and reopen my program i can see ALL record.

but the problem is all present if i add new record.

-----------------------------------
Delphi 2010 UPD 5 + EDB 2.07

Update


if i start with a Empty table  ( Table with any records but when i range it
, zero record is valid ) , all work well

but..

if i start with a FULL table  ( Table with any records, when i range it , it
have any records valid ) , The bug is present.

Mauro


If I understand it correctly you have a query using RANGE, you've asked for a sensitive result set and you're inserting new records. It also sound as though the dbgrid is posting the record as soon as you press enter to finish editing any cell.

If I'm correct my guess would be that either the new record fails to match the WHERE clause in the query or it falls outside of the range you've specified.

Sensitive result sets act like a table with a filter set and if you add a record that doesn't match the filter it "disappears"

Roy Lambert [Team Elevate]

i don't use Query.

only one TEDBTable component.

Update 2


I have this problem in much Master Detail forms of my big application (
always TEDBTable + range )

i have recompiled it with old EDB 2.03 B5 and all work fine

Mauro

>i don't use Query.
>
>only one TEDBTable component.

OK but the same principle would apply. Do the records you are inserting meet the criteria in the range?

Roy Lambert [Team Elevate]

> OK but the same principle would apply. Do the records you are inserting
> meet the criteria in the range?

yes ofcourse



if i close and reopen , form , these new records are visible.

p.s.

With EDB B2.03 B5 is all ok.

Mauro


Over to Tim then.

Roy Lambert

Mauro,

<< if i start with a Empty table  ( Table with any records but when i range
it , zero record is valid ) , all work well

but..

if i start with a FULL table  ( Table with any records, when i range it ,
it have any records valid ) , The bug is present.  >>

Can you please send me an example of what you're seeing
(timyoung@elevatesoft.com) ?

Thanks,

--
Tim Young
Elevate Software
www.elevatesoft.com

Mauro,

Never mind, I've reproduced it.  It's the optimization added to B7 for
dealing with filters that only select a few rows out of many.  It's
interfering with the ranges.

The workaround is to call CancelRange/SetRange to correct the range, but
I'll have a fix out shortly for this.

--
Tim Young
Elevate Software
www.elevatesoft.com