How to SET new key to RecRef

ajaybabuCh

Hello


recRef.OPEN(122); -- opening the Purch. Inv. Header

FldRef := recRef.FIELD(44);--- Order No field ref
FldRef.SETRANGE('106015');--- filtering the Purch. Inv. Header table with the Order Number Value.
IF recRef.FINDFIRST THEN;

recRef is using the default primary key or the Purch. Inv. Header Table.

I would like to set a new key that is Order Number , to search for the records effectively by FldRef.SETRANGE('106015');

Can anybody help me how to SET new key to the recRef

Thanks and Regards
Ajay

garak

Try to use

REcRef.CURRENTKEYINDEX

;-)

Regards

ajaybabuCh

Thanks garak

I need some sample code for the following

If I have the field number in the current table , for example take field number 44 (Order No.) in Purch. Inv. Header table.
I would like to get the key index which will contain the field number 44 from the current table pointing by the RecRef.

kine

Just search for example for using KeyRef. E.g. http://www.mibuso.com/dlinfo.asp?FileID=895

garak

sometimes its very easy to open the C/AL Editor and press F1 on the selected function. So, you get the halp and a example, also for REcRef .

Regards