Function EN Version 1.90

@OpenNoteByID

Database Note

Syntax

@OpenNoteByID(DBHANDLE1;NOTEID2;NOTEHANDLE3);
@OpenNoteByID(DBHANDLE1;NOTEID2;NOTEHANDLE3;FNOPTIONS4);

Description

Opens the document in the database with the DBHANDLE DBHANDLE1 and the ID NOTEID2 and returns the NOTEHANDLE NOTEHANDLE3 returned. Options can be specified using the optional parameter FN FNOPTIONS4 can be used to specify options.

Note:
Changes to a design document may lead to unexpected results.
It is recommended to use this @Function only for read-only access, or only in an appropriate context.

FNOPTIONS4:
BIT   DEC   HEX   Meaning if set

01   00000001   00000001   Open Summary only
02   00000002   00000002   Open Verify default
03   00000004   00000004   Expand all TEXT/NUMBER/TD … Variables to Lists with 1 Element
04   00000008   00000008   Without Objects
05   00000016   00000010   Reserved/Unknown
06   00000032   00000020   Open in Shared Memory Mode
07   00000064   00000040   Return all Item Values in Canonical Data Form
08   00000128   00000080   Reserved/Unknown
09   00000256   00000100   Mark unread if unread list is currently associated
10   00000512   00000200   Only open an abstract of large documents
11   00001024   00000400   Reserved/Unknown
12   00002048   00000800   Reserved/Unknown
13   00004096   00001000   Return Response ID Table
14   00008192   00002000   Reserved/Unknown
15   00016384   00004000   Reserved/Unknown
16   00032768   00008000   Reserved/Unknown
25   16777216   01000000   Convert TYPE_RFC822_TEXT Fields to TEXT/TD
26   33554432   02000000   Convert TYPE_MIME_PART Fields to RT (CD’s)

Example: @OpenNoteByID(DBHANDLE1;NOTEID2;NOTEHANDLE3)

DBHANDLE1:=@OpenDB("TEST.NSF");
NOTEHANDLE3:=@OpenNoteByID(DBHANDLE1;28992;NOTEHANDLE3);
NOTEHANDLE3:=@CloseNote(NOTEHANDLE3;0);
DBHANDLE1:=@CloseDB(DBHANDLE1);

A database is opened, a document is opened by its ID opened, closed, and finally the database is closed again.

Note : This text was machine-translated and may contain inaccuracies.