get a record based on two values

olaf

Hallo,

I need to select a value from a database with getRecord. The problem is, that I have to select a warehouse code from the report header to use this code to select later in the line the right sku to get a record identified with the item number.

this could be the code to get the Record:

IF getLocation.GET ("Item No.") THEN ...

how can place the value for the SKU?

RobertMo

Maybe you should check the PrimaryKey of the record you wnat to retrieve and then decide whether to use rec.GET or rec.FIND function.

And of course read carefully help for both functions (and some more also). Then you will get the idea.

olaf

Hallo Robert,

never used rec.FIND before, i will give it a try.

The problem is what i see is, I got a stock keeping code from the header. then in the row i have to select a location based on an article number and the stock keeping code from the haeder. I will keep you informed tomorrow...

Jelias1

GET() only works if you give it the parameters of the primary key. However, you can use FIND('-') to get a record. Many times you can narrow a search down to one record using FIND, even though it is capable of returning multiple records that meet the search criteria. You establish the criteria by using SETRANGE and SETFILTER on the table variable that calls FIND. Hope this helps.
hj

olaf

Hallo,

Thank you all for the help...

The example for FIND in the manual (ver. 3.10a) is a little strange (not really about the find function).

Maybe someone can post a short example about how to use the function?

Jelias1

CLEAR(AEICheckSalesLine);
JECheckSalesLine.RESET;
JECheckSalesLine.INIT;
JECheckSalesLine.SETRANGE(JECheckSalesLine."Document Type","Document Type");
JECheckSalesLine.SETRANGE(JECheckSalesLine."Document No.","Document No.");
JECheckSalesLine.SETFILTER(JECheckSalesLine."Shortcut Dimension 1 Code",'<>%1','');
IF JECheckSalesLine.FIND('-') THEN BEGIN

This example shows how to use a combination of SETRANGE and SETFILTER to narrow down the search.

The rule I follow is to use GET if I have all of the primary key information and to use FIND if I do not have the full data of the primary key.

Hope this helps.
j

awarn

One more tip which is an absolute necessity if you are using SQL backend:

ALWAYS before setting ranges use a setcurrentkey. AS MUCH AS POSSIBLE the key you use should contain the fields you are sorting by, and the set ranges should be in the same order as the fields in the key.

If you do not use a SETCURRENTKEY Navision will assume you want to use the primary key, which if you are doing a FIND should really not be the best key at all...

JECheckSalesLine.RESET;
JECheckSalesLine.INIT;

JECheckSalesLine.SETCURRENTKEY("Document Type", "Document No.", "Shortcut Dimension 1 Code");

JECheckSalesLine.SETRANGE(JECheckSalesLine."Document Type","Document Type");
JECheckSalesLine.SETRANGE(JECheckSalesLine."Document No.","Document No.");
JECheckSalesLine.SETFILTER(JECheckSalesLine."Shortcut Dimension 1 Code",'<>%1','');
IF JECheckSalesLine.FIND('-') THEN BEGIN


Take it from someone who has spent time re-writing posting routines to make them faster...

-a

Jelias1

An excellent point. It made me rewrite my routine. Thanks.

olaf

@Jelias1

thanks, it works perfect!!!