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.