TUniTable.UniDirectional lead to read only dataset (MSSQL)

[cross_join]

Hello,
When I set TUniTable.UniDirectional property to "true" and try to add a new record I get the error "dataset is read only".
Is it specific for MSSQL and Provider=prDirect?
Issue was reproduced with UniDAC 6.1.6 on Lazarus 1.4 and Delphi 7.

Any workarounds are welcome.

[azyk]

For datasets in UniDirectional mode data is read-only. This is correct behavior of UniDAC. This behavior is not specific for Provider=prDirect, It will be the same for the other providers (prAuto, prSQL, prNativeClient).

See more details about UniDirectional in our documentation: https://www.devart.com/unidac/docs/?dev ... tional.htm .

[cross_join]

Thank you for replying.
However, there is no relation between UniDirectional and ReadOnly in documentation.
On other hand, UniDirectional doesn't make dataset read-only with PostgreSQL, the scrolling forward and adding the data work fine with cached updates. It's not the case with MS SQL.

[azyk]

We will investigate this behavior of UniDAC for PostgreSQL and inform you about the results.