User SELECT ACTION processing.

James B. Byrne byrnejb at harte-lyne.ca
Tue Oct 25 10:13:12 CDT 2022


Related to my previous message.  I am trying to discover if it is possible to
use a calculated value in a user specified SELECT action.  The example is a
foreign currency (FC) amount which is converted to the local currency (LC) when
stored and reconverted into the foreign currency when displayed; both using an
exchange rate stored in the record.

The FC is entered into the FIELD of the local currency amount and converted in
an INPUT procedure to the LC value.  A corresponding OUTPUT procedure
calculates the displayed value.

I can create a DEFINE which will give the FC value when a record is retrieved. 
However, I cannot determine how to use a value entered in the FIELD by a USER
SELECT action to compare against this DEFINE.  Is this possible?



-- 
***          e-Mail is NOT a SECURE channel          ***
        Do NOT transmit sensitive data via e-Mail
   Unencrypted messages have no legal claim to privacy
 Do NOT open attachments nor follow links sent by e-Mail

James B. Byrne                mailto:ByrneJB at Harte-Lyne.ca
Harte & Lyne Limited          http://www.harte-lyne.ca
9 Brockley Drive              vox: +1 905 561 1241
Hamilton, Ontario             fax: +1 905 561 0757
Canada  L8E 3C3



More information about the powerh-l mailing list