FieldDefs InternalCalcField

christio · Post by **christio** » Thu 07 Oct 2010 07:45

Hi,

How can I check if a field in a dataset (TIBCQuery) is a computed field?

CREATE TABLE RENNEN (
ID BIGINT NOT NULL,
SKILEHRER BIGINT,
COALESCED_SKILEHRER COMPUTED BY (coalesce(skilehrer, 0))
);

Neither Fields.ReadOnly nor FieldDefs.InternalCalcField returns true for the field "COALESCED_SKILEHRER". The dataset is filled with an SELECT statement.

Regards, ch.

AndreyZ · Post by **AndreyZ** » Thu 07 Oct 2010 12:25

Hello,

You cannot check that the field is computed by database. The fkCalculated and fkInternalCalc field types are used only for Delphi calculated fields. For database computed fields the field type is fkData.

christio · Post by **christio** » Thu 07 Oct 2010 12:50

With the IBX components the Fields.ReadOnly property was set to True if a field was computed by the database.

AndreyZ · Post by **AndreyZ** » Fri 08 Oct 2010 14:31

IBDAC doesn't support this functionality. We will investigate the possibility of adding this functionality in the future. As soon as we solve this question we will let you know.

christio · Post by **christio** » Mon 11 Oct 2010 08:58

Ok, thank you.

Dimon · Post by **Dimon** » Fri 29 Oct 2010 09:49

To solve the problem set the TIBCQuery.Options.DefaultValues property to True.