Fields after opening dataset readonly, although SetFieldsReadOnly is True

[freim]

When using an editable view I can' nt update some fields because they are created as readonly.
(I dont use persistent fields)
Setting Dataset.Options.SetFieldsReadOnly := False has no effect.
As a workaround I change then fields ReadOnly - property in code after opening.

In views I often use field definitions like

Code: Select all

iif(db.id is null, 'F', 'T')
coalesce(u.sec$active, false)

Such fields are readonly after open the query.

It would be very userfull, if such fields would be editable, if Dataset.Options.SetFieldsReadOnly is False.
So far I used IBObjects - there it works as expected.

Thanks

Frank Reim

[oleg0k]

Hello,
Unfortunately, we haven't been able to reproduce the issue based on your description. Please send us a sample project demonstrating the incorrect behavior and the script for creating the database objects through the contact form: https://devart.com/company/contactform.html
Please specify your server (Firebird or InterBase) and its version.
You can learn more about the SetFieldsReadOnly property in the IBDAC documentation: https://www.devart.com/ibdac/docs/devar ... adonly.htm

wbr, Oleg
Devart Team