I am using TTMSFMXGrid
component last vers.(220.127.116.11) 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.
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.
Dear Pieter thank you for your help.
The TTMSFMXGrid does not automatically
post, but you can change this behavior by setting the following property:
I am having this exact same problem. I do not see a response from Pieter with a solution.
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.
Could you perhaps send us your sample so we can investigate this here?