Kbase P98618: How to automatically update the value of a calculated field without repositioning the query in a bro
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
09/12/2004 |
|
Status: Unverified
GOAL:
How to automatically update the value of a calculated field without repositioning the query in a browse
GOAL:
How to automatically update the value of a calculated field without moving the current record to the top of the browse
GOAL:
How to move the cursor to the next record and automatically update the value of a calculated field in a browse
FIX:
Copy the following code to a VALUE-CHANGE trigger of the browse.
DEFINE VARIABLE i AS INTEGER NO-UNDO.
i = QUERY browse-1:CURRENT-RESULT-ROW.
/* this will hold the current row of the browse */
{&OPEN-QUERY-{&BROWSE-NAME}}
/* this will reopen the query to allow calculated field to be updated */
BROWSE-1:SELECT-ROW(i).
APPLY 'ENTRY' TO qty IN BROWSE browse-1.