GET is the basic data retrieval procedure in AL. GET retrieves a single record based on the primary key only. It has the following syntax:
[BooleanValue :=] Record.GET ( [KeyFieldValue1] [,KeyFieldValue2] ,...)
The parameter for the GET procedure is the primary key value (or all of the values, if the primary key consists of more than one field).
Assigning the GET procedure result to BooleanValue is optional. If the GET procedure is not successful (no record found) and the statement is not part of an IF statement, the process will terminate with a runtime error. Typically, therefore, the GET procedure is encased in an IF statement, which is structured like so:
IF Customer.GET(NewCustNo) THEN ...
GET data retrieval is not constrained by filters, except for security filters (see help, How to: Set Security Filters at https://msdn.microsoft.com/en-us/library/hh166853(v=nav.90).aspx). If there is a matching record in the table, GET will retrieve it.
