[DevExpress Support Team: CLONED FROM A343: How to set a value of another Grid column during editing of a cell]
Hi Paulo,
I have tried this solution but dosn't works. I implemented this to my scenario, but the SetEditValue dosn't change the cell, because internal in the CanInitEditing / CanModify / IsSyncMode / IsDataSetCurrent returns false. My detail dataset is in sql mode (DetailIsInSQLMode = True), can this produce this problem? If yes, can you suggest me an another solution to automatically change a field, if an other was changed by the user? I use FireDAC with parameterized TFDQuerys in master detail scenario.
This is urgent, please give me a quick workaround!
Regards,
Péter
I do not think that the DetailIsInSQLMode property is the cause of this problem. I have just checked how the solution provided in the A343 article works with ADO queries and detail values are correctly modified on my side. It seems that something else is involved at your end. Please check the attached sample project where I applied the A343 solution to the detail view with the [DetailIsInSQLMode = True] setting. I hope this demo project will help you implement the same approach in your project. Please keep me informed of your progress.
Ok, I try to debug, when and why will the Provider-FIsDataSetCurrent equal false. What does IsDataSetCurrent mean?
The IsDataSetCurrent property is an internal property that is set by a complex condition inside the TcxDBDataProvider.GetIsDataSetCurrent method. This is not a documented property, so I suggest that you do not change it.
I don't want to change it, I just would like to know, why is it false.
I see. Thanks. In this case it is necessary to debug the TcxDBDataProvider.GetIsDataSetCurren method and its complex condition.