TTMSFMXGrid database update problem

FMX TMS FMX UI Pack
1

I am using TTMSFMXGrid component last vers.(2.2.2.1) and FireDac Component for connection SQLite. Grid connected TFDQuery (FireDacQry) LiveBinding. Records are shows normally.

Problem is, when i change the records database can not updated.  ex: I have a table with 5 fields. If i change records on GridCell it looks ok grid shows the records correctly but database does't updated. if i close the program and open again i show just 1 field was updated. only first changes affects.

when i try same scenario with TGrid (Default delphi grid) All is ok. All records updated.

I hope
can i explain the problem. I think it is Grid bug. If you need detail can i record my screen and send you a
small video for this bug. Pls tell me if there is a another option or settings
send me. I cheked user manuals and your offical documents, also i am searching
this bug web. I can not find any solituons.


Thank you for your help.
2

Dear Pieter thank you for your help.

The TTMSFMXGrid does not automatically post, but you can change this behavior by setting the following property:

TMSFMXGrid1.Options.Editing.AutoPost := apCell;

3

I am having this exact same problem. I do not see a response from Pieter with a solution.



Thanks,



Glenn House

4

Pieter sent the answer:

The TTMSFMXGrid does not automatically post, but you can change this behavior by setting the following property:

TMSFMXGrid1.Options.Editing.AutoPost := apCell;

by direct email and it was reposted here by original poster.

5

Pieter,



I am using a SQLite date file, accessing it through a ClientDataSet (using LiveBindings to connect the ClientDataSet to a TMSFMXGrid). Changing the property as you suggested, does post the information to the ClientDataSet as soon as you leave the edited cell. However, when I call ClientDataSet.UpdateAll(0) to send the changes to the SQLite data file, only one field is updated. I used the same process with a TStringGrid and the SQLite data file was properly updated.



Also - one of my fields is a date field. In the TStringGrid, there is no problem editing that field, but when I try to edit it in the TMSFMXGrid, it leaves a blank field.



Thanks,



Glenn House

6

Dear Glenn, 


Could you perhaps send us your sample so we can investigate this here?

Kind Regards, 
Pieter