JavaScript Editor js editor     Web development 



Main Page

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(В ) and EOF( ) Function functions 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



JavaScript Editor js editor     Web development