I am using a grid to display data from a db. And I need to tint a row, depending on the data in the cells. But in the TMSFNCGrid1GetCellLayout event, I can't get data from the cell. TMSFNCGrid1.StrippedCells[acol,arow] - empty data is coming. Why doesn't StrippedCells in this event emit the data in that cell?
Hi,
The data is not stored when connected to a dataset when an active connection. You need to fetch the data from the dataset yourself, or use the TMSFNCGridDatabaseAdapter1.LoadAllDataAndDisconnect, which will then load all the data in the grid. Afterwards you can use the StrippedCells property to retrieve the data.
It turns out that after each request to do LoadAllDataAndDisconnect? And at the beginning of the query TMSFNCGridDatabaseAdapter1.active := true ? Can't do without it? somehow you have a non-standard case in the grid. Is it possible to enable it to always receive data?
The LoadAllDataAndDisconnect method disables the connection to the dataset.
The data is not stored, it's dynamically retrieved for performance reasons. We'll investigate how we can provide the data when requested without storing it. At this moment this is not possible while maintaining an active connection.
Yes thank you! It would be very helpful!