IBCQuery Editor, brings computed fields as update field

[josecarlos]

Hi,

I am using ibcquery to change data, with dataware components. It is working fine.

The only issue is with the computed fields. When I call the "IBCQuery Editor" to set the Update SQL, all fields on the "SQL Generator" TAB, are loaded on the update fields list , so I have to manually unselect the computed fields.

I think this could be automatically detected as READ ONLY field.

On the fields list, all computed fields are READ ONLY.

I am using IBDAC 3.60.0.24 and Delphi XE updated 1.

Best regards,

[AndreyZ]

Hello,

The point is that InterBase and Firebird servers don't return information that fields are computed. That's why we cannot automatically set the ReadOnly property.

[josecarlos]

Hi AndreyZ,

I am talking about the Update Fields list, on the "SQL Generator" tab.

Just to make sure we are talking about the same thing.
Right click on a TIBCQuery, choose IBCQuery Editor and finally the "SQL Generator" Tab.

On this place, the update fields loads all fields, even the non updated fields.

It will be nice to have only updatable fields there.

In the other hand, on the TFields Editor, ibdac adds the fields correctly, setting up the readonly property to true.



Thanks

[AndreyZ]

For the time being we have tasks of higher priority and, unfortunately, we don't have any time for investigating of this question. We will investigate this problem in the future.

[josecarlos]

OK!

Thanks,