ISMEMOFETCHED( ) Function
Determines if a memo field has been fetched during a delayed memo fetch.
ISMEMOFETCHED(cFieldName | nFieldNumber [, nWorkArea | cTableAlias])
Parameters
cFieldName
Specifies the name of the memo field for which the fetch status is returned.nFieldNumber
Specifies the field number (based on the physical structure of the table or cursor) of the memo field for which the fetch status is returned.nWorkArea
Specifies the work area of the table or cursor containing the memo field for which the fetch status is returned.cTableAlias
Specifies the alias of the table or cursor containing the memo field for which the fetch status is returned.
Return Value
Logical. A logical true (.T.) is returned if the specified memo field has been fetched, otherwise a logical false (.F.) is returned. True (.T.) is always returned for local data. The null value (.NULL.) is returned for a cursor if the record pointer is positioned at the beginning or end of the cursor. Use the BOF( ) Function and the EOF( ) Function to determine if the record pointer is positioned at the beginning or end of the cursor.
Remarks
It can often take a while for a memo field fetch to occur with remote data, so you may choose to not download a memo field until it is absolutely needed.
The FetchMemo setting in the DBGETPROP( ) Function and CURSORGETPROP( ) Function functions determine if a memo field is retrieved with View results or on demand. ISMEMOFETCHED( ) return true (.T.) when the memo field is fetched for delayed Memo data (FetchMemo=.F.).
ISMEMOFETCHED( ) works with both memo and general fields.