Navigation: Language Reference > App C - PROP: Runtime Properties > Runtime VIEW and FILE Properties >====== PROP:Value ====== | |
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