Notifications
Announcements
No record found.
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
When we know the all primary key field values of a record we use GET function like if you know customer no. then
Customer.GET('XXX');
Hello,
GET Function is used for finding the record based on Keys.
No need to use any filters like, SETRANGE.
Always searches through all the records in a table.
Thanks! What does Table1.GET("Entry No.",Table2."No.") mean?
Here, Table2."No." return a value that value are going to search on Table1.
For Example
Table1.GET("Entry No.",Table2."No.");
OR
Table1.GET("Entry No.",'Xyz123'); //Table2."No."
most importantly Table1 should have 2 fields in primary key which matches "Entry No." and Table2."No.".
Does Table1.GET("Entry No.",Table2."No.",Table3."No."); have any sense?
as I mentioned, you need to exactly pass no. of primary key fields.
if your primary key has 2 fields and pass 3 then wont work.
And if the primary key has 3 fields, then would this work?
yes, syntax wise it will work..
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
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 Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
