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
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.