An inserted record is hidden until the bound dataset is reactivated if the data controller whose DataModeController.SmartRefresh property is set to True is linked to this dataset using a FireDAC connection

Hello Dietrich,

From what I gather, you are using the TcxGridDBTableView class, but not TcxGridTableView. TcxGridTableView is an unbound view and it does not have the DataModeController published property.

As stated in the "TcxDBDataModeController.SmartRefresh" help topic, the key field must be specified to make this mode work. Thus, when you set the DataController.KeyFieldNames property to an empty value, the SmartRefresh mode does not work in fact. That is why the update time is so big.

As for the built-in Navigator's behavior you described, I think that this should not happen in SmartRefresh mode. This Navigator is a part of the grid control, so it has access to the grid view's DataController instance and can individually update records. Moreover, I was not able to reproduce the behavior you described in a small sample project. It seems that something else is involved at your end. Would you please modify the attached project to demonstrate the problematic behavior? Thanks in advance.

Hi,

with your TdxMemData it works fine.

I use a simple table on SQL-Server (Ver. 12):

SQL
CREATE TABLE [dbo].[TEST](  
    [ID_KEY] [int] IDENTITY(0,1) NOT NULL,  
    [Match] [varchar](250) NULL CONSTRAINT [DF_TEST_Match]  DEFAULT ('-'),  
 CONSTRAINT [PK_TEST] PRIMARY KEY CLUSTERED  
(  
    [ID_KEY] ASC  
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]  
) ON [PRIMARY]  

Attached, you can find my sample-source where you can test the issue.