Hi! I'm new in C/AL programming. Can anyone explain me the GET function, not like the "help" in nav? Thank you!
*This post is locked for comments
In addition to answers given, if it is a setup table where the primary key is empty string, The syntax "Table.GET" makes the setup table Accessible to the code.
Hi,
It works based on Primary Key field
Hi walidalam,
The GET Function (Record) retrieves one record based on values of the primary key fields.
Below links will provide you more information:
msdn.microsoft.com/.../dd338616(v=nav.90).aspx
msdn.microsoft.com/.../dd301056(v=nav.90).aspx
Ok, but what does Table1.GET("Entry No.",Table2."No.",Table3."No."); actually mean? Can you give me an easy example please? Thanks
Entry No is also part of primary key so it doesn't matter if the other 2 has same values , as long as the entry number is distinct.
Yes, but Table2."No." must be equal to Table3."No."?
no, it wont search in table 3 and 2.
you need to have those record values by the time you use them in GET function.
you need to take some training...
So, in this case, the same value is searched in both tables 3 and table 2 and then it is searched in the entry no of table 1? Thanks
yes, syntax wise it will work..
And if the primary key has 3 fields, then would this work?
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Saurav.Dhyani 2 Super User 2025 Season 2
RK-25090803-0 1
