April 2017
Intermediate to advanced
706 pages
17h 8m
English
The FIND family of functions is the general purpose data retrieval function in C/AL. It is much more flexible than GET, therefore more widely used. GET has the advantage of being faster as it operates only on an unfiltered direct access through the Primary Key, looking for a single uniquely keyed entry. There are two forms of FIND functions in C/AL, one a remnant from a previous database structure and the other designed specifically to work efficiently with SQL Server. Both are supported, and we will find both in standard code.
The older version of the FIND function has the following syntax:
[BooleanValue :=] RecordName.FIND ( [Which] ).
The newer SQL Server-specific members of the FIND function family have slightly different ...
Read now
Unlock full access