Documentation
ALRC: Create foreign key buffer table
Generate a compact read buffer for repeated foreign-key lookups.
On this page
Country buffer: the company's default country
When generating a foreign-key buffer for the standard Country/Region table, the generated code falls back to the country/region code in Company Information when the supplied country code is empty. This applies to newly generated buffers for that standard table; existing buffers are not rewritten automatically.
ALRC: Create foreign key buffer table
Creates a temporary buffer table for records that a report repeatedly reads through a foreign key. Select only the fields you need to buffer.
Only those fields are read and stored, reducing memory compared with buffering complete records. Repeated requests for the same primary key come from the buffer and do not trigger another database read.
The generated table encapsulates the buffer logic. Replace the original record variable with the temporary buffer type and use GetBuffered() instead of Get(). Event publishers let extensions add their own fields without modifying the buffer logic.