User Tools

Site Tools


prop_value.htm
Navigation:  Language Reference > App C - PROP: Runtime Properties > Runtime VIEW and FILE Properties >====== PROP:Value ====== Previous pageReturn to chapter overviewNext page

An array property of a FILE that sets or returns the data contained in a specified MEMO or BLOB column (use the WHAT procedure for any other type of column). The array element for PROP:Value is a simple negative number which indicates the MEMO or BLOB. MEMO and BLOB fields are numbered negatively. MEMO and BLOB declarations begin with -1 and decrement by 1 for each subsequent MEMO and BLOB, in the order in which they appear within the FILE structure.

Example:

Text      STRING(2000)

MoreText  STRING(64000)

Number    LONG

Customer FILE,DRIVER('TopSpeed'),PRE(CUS)

Notes     MEMO(2000)

BigText   BLOB

Record    RECORD

Number     LONG,DIM(20)

Name       STRING(20)

         END

        END

CODE

OPEN(Customer)

SET(Customer)

NEXT(Customer)

ASSERT(~ERRORCODE())

Text = Customer{PROP:Value,-1}          !Get CUS:Notes contents

MoreText = Customer{PROP:Value,-2}      !Get CUS:BigText contents

See Also:     PROP:Memos, PROP:Blobs

prop_value.htm.txt · Last modified: 2021/04/15 15:57 (external edit)