Share
ReportHi! 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
You’re offline. This is a read only version of the page.
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:
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?
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
All responses (
Answers (