OPEN Function (RecordRef)

Causes a RecordRef variable to refer to a table, which is identified by its number in a particular company.

RecordRef.OPEN(No[, Temp][, CompanyName])

Parameters

  • RecordRef
    Type: RecordRef
  • No
    Type: Integer The number of the table.
  • Temp
    Type: Boolean
  • CompanyName
    Type: Text or code The name of the company to which you want to change. If you omit this parameter, the current company is used.

Remarks

When you use the RecordRef.OPEN function a new object is created. This object contains references to the open table, filters, and the record itself and all the fields it contains. You can open a table by using the table number or the name of the table that represents the table number. For example, you open the Customer table by using following syntax: RecordRef.Open(18) or RecordRef.Open(DATABASE::Customer)

If you use the CompanyName parameter, then this function works the same as the CHANGECOMPANY Function (Record).

Example

The following example uses the OPEN function to create a RecordRef variable that is named MyRecordRef for the Customer table. The parameters are omitted in this example because there is only one company in this example and the table will not be open as temporary table. The caption and number of records in the table are displayed in a message box. At the end of the display, the CLOSE Function (RecordRef) closes the table. This example requires that you create the following variable and text constants in the C/AL Globals window.

Variable name DataType

MyRecordRef

RecordRef

Text constant name DataType ENU value

Text000

Text

'The %1 table contains %2 records.'

MyRecordRef.OPEN(DATABASE::Customer);
MESSAGE(Text000, MyRecordRef.CAPTION, MyRecordRef.COUNT);
MyRecordRef.CLOSE;

This example shows how to use the OPEN function. In this example, "MyRecordRef" opens table 27 and then "FIND('-')" finds the first record in the table. "TempMyRecordRef" opens a temporary table which is empty and therefore the "FIND('-')" returns false. This example requires that you create the following variables in the C/AL Globals window.

Variable name DataType

MyRecordRef

RecordRef

TempMyRecordRef

RecordRef

MyRecordRef.OPEN(27,FALSE);
TempMyRecordRef.OPEN(27,TRUE);
IF MyRecordRef.FIND('-') THEN // This is true and will find the first record in the table.
  MESSAGE('MyRecordRef finds')
ELSE
  MESSAGE('MyRecordRef does not find');
IF TempMyRecordRef.FIND('-') THEN // This is false because there are no records in a temporary table.
  MESSAGE('TempMyRecordRef finds')
ELSE
  MESSAGE('TempMyRecordRef does not find');

See Also

Reference

GETTABLE Function (RecordRef)
CHANGECOMPANY Function (Record)
RecordRef Data Type