get function

sharon95

If a table has only one primary key, and I want to use the get function to search a record corresponding at one value, how can I do it? thanks!

Kishorm

Yes, a primary key can be made up of more than one field

ishwarsharma016

You must use RecordVariable.GET(Field1Value) to that the desired record. The number of values which go inside the GET function are the number of fields in the Primary key of the RecordVariable's table.

Note that a table can have only one primary key.

Please check this https://msdn.microsoft.com/en-us/library/dd301056(v=nav.90).aspx to get more knowledge on GET function.

sharon95

@ishwarsharma016 "a table can have only one primary key"!?!?

binilabraham

Yes. Please go through this link;
https://msdn.microsoft.com/en-us/library/dd338755.aspx

RockWithNAV

Table.GET('Respective value which you want to look for');

Like - Item.GET(SalesLine."No.");

sharon95

binilabraham wrote: »

Yes. Please go through this link;
https://msdn.microsoft.com/en-us/library/dd338755.aspx

but a primary key can be made up of more than one field, right?

Kishorm

Yes, a primary key can be made up of more than one field

Jan_Veenendaal

If you have more fields in the primary key, but you want to search on just one of these values, than you cannot use GET

In that case use SETFILTER or SETRANGE, and then FINDFIRST/FINDSET/FINDLAST.

Example for table 36 'Sales Header' that has 2 fields as primary key: "Document Type" and "No.". Now if you know the document number, like 'SO-W001' you could write:

SalesHeader.SETRANGE("No.", 'SO-W001');
IF SalesHeader.FINDFIRST THEN
  MESSAGE ('%1 has document type %2',SalesHeader."No.",SalesHeader."Document Type");