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.

FRAME-FILE function

Syntax

Example

Notes

See also