Hi
I have discovered that update sql executed via TFDConnection.ExecSQL against a TFDMemTable fails with "List index out of bounds (8)" when there is a calculated field in the dataset. In this case the first calculated field has index 8 (9th field) as referenced in the error message. If I remove the calculated field, the update executes without issue.
I assume, then, that the update tries to do something with the calculated fields that it shouldn't... is there a way to avoid this?
Thanks