Click or drag to resize

DbMemoField Function

X#
Return the memo field pointer of a DBF record.

Namespace:  XSharp.RT
Assembly:  XSharp.RT (in XSharp.RT.dll) Version: 2.21
Syntax
 FUNCTION DbMemoField(
	uField AS USUAL
) AS USUAL
Request Example View Source

Parameters

uField
Type: Usual
The name, number, or symbol representing the desired memo field.
If omitted, defaults to the first memo field in the database, if any.

Return Value

Type: Usual
The contents of the specified memo field within the DBF record, if successful; otherwise, NIL.
Remarks
DBMemoField() returns the 10-byte value of a memo field within the DBF.
This value can be used for special purposes, because it's actually a pointer (or offset) of the appropriate memo block within the associated memo file.
Examples
The following example demonstrates the DBMemoField() function:
X#
 1FUNC TestMField
 2    LOCAL n         AS INT
 3    LOCAL cMemoOffs AS STRING
 4    USE demo1 VIA "DBFCDX"
 5    n := FieldPos("comment")
 6    DO WHILE !EOF()
 7    cMemoOffs := DBMemoField(n)
 8    ? RECNO(), cMemoOffs
 9    SKIP
10    ENDDO
11    CLOSE
See Also