Problem with edit in filtered dataset

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
dartas
Posts: 18
Joined: Mon 12 Jan 2009 14:40

Problem with edit in filtered dataset

Post by dartas » Tue 15 Dec 2009 07:14

Hello,

small sample:

Code: Select all


query.filter := 'some filter';
query.filtered := true;
query.insert;
query.post;
query.edit;

strange what after posting, editing record is old record which was focused on filtered dataset, but not new record. if filter = false all is ok.

D2010, latest sdac

Dimon
Devart Team
Posts: 2885
Joined: Mon 05 Mar 2007 16:32

Post by Dimon » Tue 15 Dec 2009 08:28

I could not reproduce the problem.
Please send me a complete small sample to dmitryg*devart*com to demonstrate it, including a script to create and fill table.

dartas
Posts: 18
Joined: Mon 12 Jan 2009 14:40

Post by dartas » Tue 15 Dec 2009 15:12

done.

Dimon
Devart Team
Posts: 2885
Joined: Mon 05 Mar 2007 16:32

Post by Dimon » Wed 16 Dec 2009 14:48

Thank you for information.
The point is that when you insert new record, that doesn't meet a filter’s conditions, then on posting this record become not available. And after posting cursor go to the next available record.

Post Reply