If you are talking about a field calculated in Firebird through COMPUTED BY, then what is sent to the client (your program) when you issue a SELECT is the value of this field, not the formulae. The client may not even know the field is computed and think it is just a separate field.

The two possible ways to get the field updated, would be to either refetch the data (so that the server gets to calculate the value again) or do the calculation on the client (i.e. programmatically in your program).

Set

-----Original Message-----
From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] On Behalf Of Luis Fernando - HW Sistemas
Sent: 15. februar 2011 22:12
To: firebird-support@yahoogroups.com
Subject: [firebird-support] No Refresh with Calculated field and TClientDataSet

Hi all, [Delphi2010 + DBExpress + FB 2.5]

I am using a TClientDataSet (+Provider+SQLQuery) with a table that has a
simple calculated field (it returns StrField1 + StrConstant +
StrField2). I use DBCtrlGrid to view the data.
When I edit a record and change StrField1 (with CDS.Edit and .Post,
outside the grid), all the other edited fields are refreshed on the
DBCtrlGrid, with the exception of the calculated field.
If apply the updates, the new data is correctly there.

I read many posts but couldn´t find a clue.
Any help?

Thanks,
Luis Rocha