Hi Keeley;

  I would add the Oracle Function value as a "Retrieval Argument" to the DW object. Then just pass the RA into the DW Control / DataStore's Retrieve() command. The DW Object within the DC/DS can then use the value of the new RA for its own processing purposes (does not have to be SQL related). Thus, it can be used in a computed column, DWO expression, Child DWO, etc. as you require.

Food for thought.

Regards ... Chris

In that case, wrap the Describe() function (which returns a string) in a number conversion function such as Integer(string), Dec(string), Long(string), Real(string), depending on the type of numeric value you will be adding to the converted string. For example:

Long(Describe('t_new_value.text'))

Thank you Marco & John for the quick responses! Describe() does almost what I was attempting, but I actually want to add the number in my text field to the number from the column and display the total, rather than just append. The datatype of the column is a number and the value from the text box is a string datatype.

Hi,

you can use Describe() method, which is also available as datawindow expression function. 

Therefore you can use it in compute fields, for example:

Describe("textboxname.text")

Best,

.m