April 2017
Intermediate to advanced
706 pages
17h 8m
English
GET is the basic data retrieval function in C/AL. GET retrieves a single record based on the primary key only. GET has the following syntax:
[BooleanValue :=] Record.GET ( [KeyFieldValue1] [,KeyFieldValue2] ,...)
The parameter for the GET function is the primary key value (or all the values, if the primary key consists of more than one field).
Assigning the GET function result to BooleanValue is optional. If the GET function 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 function is encased in an IF statement structured like the following code snippet:
IF Customer.GET(NewCustNo) THEN ...
Read now
Unlock full access