Links are not active on this page.
 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.

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

Expand imageRemarks

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.

Expand imageSee Also