User SELECT ACTION processing.

[James B. Byrne]

On Tue, October 25, 2022 16:01, Robert Deskin wrote:
> If I understand this correctly, the user enters S in the Action field, and then
> either enters the field ID of the Foreign Currency (FC) field or is prompted
> automatically. The INPUT procedure for FC calculates the local currency.
>
> Do you want to select/retrieve based on the calculated FC value?
>
> Would a SELECT statement work? I can’t remember whether you can specify a
> DEFINE that would be used in the statement. Or whether you can restrict it to
> the situations you want. But something like
>
> FILE <yourfile>
> DEFINE FC = <FC calculation>
> SELECT IF FC of <yourfile> = FC
>
> Don’t know if I’ve got the correct LC vc FC, but if I remember correctly,
> and it’s been a long time, the SELECT operate on each record retrieved. The
> DEFINE should be calculated when referenced by the SELECT. If the SELECT fails,
> the record is bypassed and the next record is read, and so on.
>
> Anywhere close?
>
> Bob

My difficulty is I only want the FILE SELECT to have effect IFF the user enters
SELECTMODE AND the SELECTed FIELDS include the AMOUNT FIELD. The flaw with this
approach is that what ever the USER enters in the AMOUNT FIELD is going to
filter records in addition to the FILE SELECT clause.  What I am trying to do
is to replace the SELECT value with the calculated value.  However, QDESIGN
does not appear to me to have a way to intercept and change the SELECTed
values.

Regards,


-- 
***          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