2. PHPRunner General questions
  3. Field Calculations
This topic is locked

Field Calculations

 		4/25/2007 2:38:36 AM
PHPRunner General questions
D
 dcrera author

Hi,
On the Sql select statement I have
*select order_qty, price, order_qty price as totalval ...
I set totalval** as a ReadOnly.
Totalval is a display field and not on the database.
When I try to update the record I get the following message
ociexecute() [function.ociexecute]: ORA-00904: "TOTALVAL": invalid identifier
Any suggestions on how I can avoid this ?
Thanks
J
 		Jane 4/25/2007

Just remove totalval field from the Add and Edit pages on the Choose fields tab.
D
 		dcrera author 4/25/2007

Hi,
I need Totalval on my edit page to show the extended value.
Any work arounds ?
Thanks again

Just remove totalval field from the Add and Edit pages on the Choose fields tab.
J
 		Jane 4/26/2007

Hi,
you can't use non-existent field on the Add/Edit page.

As workaround you can create this field in the database directly and update value of this field in the Before record added and Before record updated events on the Events tab.
D
 		dcrera author 4/26/2007

Hi,
My DBA kicked me out of his office with that suggestion.
Can I not use global variables to display the extended value ? I so, how.
Thanks again

Hi,

you can't use non-existent field on the Add/Edit page.

As workaround you can create this field in the database directly and update value of this field in the Before record added and Before record updated events on the Events tab.
Alexey admin 4/26/2007

You shouldn't get this error if your field is ReadOnly on Edit page.
Do you use Before record edited event ?