Partilhar via


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.

See Also

Reference

CURSORGETPROP( ) Function
DBGETPROP( ) Function