FRAME-FILE function

Returns the name of the database table that contains the field the cursor is in. The FRAME-FILE function is useful if you want to provide users with context-sensitive help.

Note:

Does not apply to SpeedScript programming.

Syntax 

 

FRAME-FILE

Example 

This procedure updates fields from the Order table and the Customer table. It uses the FRAME-FILE function to tell you which table contains the field being updated.

 

r-frfile.p

FOR EACH Customer, EACH Order OF Customer:   DISPLAY Order.OrderNum WITH CENTERED ROW 2 FRAME onum.   UPDATE     Customer.CustNnum AT 5 Order.CustNum AT 30 SKIP     Customer.Name AT 5     Customer.City AT 5     Customer.State AT 5     Customer.PostalCode AT 5     WITH ROW 8 CENTERED 1 DOWN NO-LABELS EDITING:     MESSAGE "The field" FRAME-FIELD "is from the" FRAME-FILE "file".     READKEY.     APPLY LASTKEY.   END. /* EDITING */ END.

Notes 

FRAME-FILE returns a null string if the frame field being entered is not associated with a database field.

If the cursor is not in an enabled input field when the last input statement ends, FRAME-FILE returns a null string.

The FRAME-FILE value is set to blanks at the next PAUSE statement, at the next READKEY statement, or when the AVM pauses automatically.

See also 

FRAME-FIELD function, FRAME-VALUE function, PROGRAM-NAME function