I'm trying to find out how TMSFNCGrid and TMSFNCGridDatabaseAdapter work with data.
I'm doing a simple FMX demo with Delphi 10.4,
TMSFNC UI Pack 126.96.36.199, FirebirdSQL Database.
FDCConnection, FDQuery, DataSource, TMSFNCGridDatabaseAdapter, TMSFNCGrid.
FDQuery contains a selection for a single table.
If I edit a cell and the data is not accepted by the server check constraint, an exception occurs and the grid is out of sync.
I can navigate to another row with mouse or arrow keys, I can edit, but the value is related to the record in the dataset that remained in the edit state.
I have seen that TMSFNCGrid is not compatible with LiveBinding
What is the best way to use TMSFNC with databases?
What can I read / learn to use TMSFNC correctly?