Page 1 of 1
TUniTable.UniDirectional lead to read only dataset (MSSQL)
Posted: Tue 09 Feb 2016 14:53
by 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.
Re: TUniTable.UniDirectional lead to read only dataset (MSSQL)
Posted: Wed 10 Feb 2016 09:45
by 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 .
Re: TUniTable.UniDirectional lead to read only dataset (MSSQL)
Posted: Wed 10 Feb 2016 10:13
by 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.
Re: TUniTable.UniDirectional lead to read only dataset (MSSQL)
Posted: Tue 16 Feb 2016 12:17
by azyk
We will investigate this behavior of UniDAC for PostgreSQL and inform you about the results.