BorlandTalk.com

ramesh yadav · Guest

Hi,

We are in the process of swapping over TStoredProcs loaded via BDE with
TClientDatasets, no BDE.

I am pointing the DSP to the original TStoredProc to load in the data into
the CDS.

There are 3 calculated fields on the original stored proc. When I go to CDS
field editor and add all fields, these come over, from stored proc, as
fkData and not fkCalculated. Therefore OnCalcFields on the CDS never fires
because there are none of that type.

Question set 1 or 2, why does this happen? It means that I have to re-create
the calculated fields from scratch on the CDS. Is there a way round this?

Therefore, I deleted these 3 fields from the CDS and added three new
calculated fields, using the same field name as those in the original stored
proc calculated field names.

Now OnCalcFields on the CDS does fire BUT I get [Field "Total" cannot be
modified] error message when I try and set the value of the calculated field
in the CDS.

I checked CanModify on the TField and it is FALSE, although ReadOnly on the
TField is FALSE as well. I cannot call EDIT on the CDS as I get an access
violation.

Quesiton set 2 of 2: Does anyone know why I cannot change the value of the
calculated field in the OnCalcField event? Have I missed out a step or do I
need to do it in a different fashion?

Thanks very much
Ramesh

vavan · Guest

On Thu, 28 Aug 2003 17:17:25 +0100, "ramesh yadav"
<ramesh.yadav (AT) roomsolutions (DOT) net> wrote:

use InternalCalc field instead

--
Vladimir Ulchenko aka vavan