Stored column in ToracleDataSet

[lavernhe]

Hello,
I want to know if it's possible to create a column in TOracleDataset that stores value which is neither calculated nor a database field. The values in this column could be used just to be displayed and not to be stored in a database.
Thanks

 

[Marco Kalter]

That is what calculated fields are for. Or am I missing something?

Edit: If you want to store a value, you can use an InternalCalc field.

[This message has been edited by mkalter (edited 19 December 2002).]

 

[lavernhe]

With a multi-threads listening system, the client application is notified by the Oracle database (by trigger) when a record is changed by another user. We just want to create a column named 'CHANGED' and set to 'Y' the record which has changed.
If I create a calculated field and set the field with the instruction :
OracleDataSet1CHANGED.Value := 'Y' ;
When I scroll, the column is re-calculated and the value 'Y' disapear. The value is not stored.

 

[lavernhe]

With a multi-threads listening system, the client application is notified by the Oracle database (by trigger) when a record is changed by another user. We just want to create a column named 'CHANGED' and set to 'Y' the record which has changed.
If I create a calculated field and set the field with the instruction :
OracleDataSet1CHANGED.Value := 'Y' ;
When I scroll, the column is re-calculated and the value 'Y' disapear. The value is not stored.

 

[Marco Kalter]

You should use an InternalCalc field (fkInternalCalc) instead of a Calculated field (fkCalculated).

That should probably do the trick.

------------------
Marco Kalter
Allround Automations

 

[planas]

Hello

I try to create an InternalCalc field. I have the following error : "OracleDataset1 : Field "MyFieldName" not found.

How i do :
1

 

[Marco Kalter]

You need to include a calculated field in the SQL text of your query, of the appropriate data type and size. This field can be set to fkInternalCalc, and can be manipulated.

------------------
Marco Kalter
Allround Automations

 

[planas]

Exact. You are right.
I set this select text : select rowid,col1,col2,'' calcCol from atable

I set calcCol to fkInternalCalc.

Important note : don't forget to do an edit before setting a value to calcCol.

Thanks.

Originally posted by mkalter:
You need to include a calculated field in the SQL text of your query, of the appropriate data type and size. This field can be set to fkInternalCalc, and can be manipulated.