get value with non-primary key field

dhaval Member Posts: 1

2016-08-30 in NAV/Navision Classic Client

i'm new in navision ,
i want to get data without using primary key.
example:=
table:-service tax entry(str-record variable)
-vendor ledger entry(vle-record variable)
-variable(date-datatype)
(i want 'document date' field from vendor ledger entry through 'party code' and store it in variable)
MyCode:
str.setrange('str.partycode','00012');
if str.find('-') then begin
vle.setrange(vle."vendorno",str."partycode");
variable := vle."documentdate";//<-- not return value
end;

please suggest me right code.

0

Best Answer

• 

  Kishorm Member Posts: 921

  2016-08-30 Answer ✓

  Hi, You need a find('-') for the vle record just after the SETRANGE similar to what you have done for the str record

  1

Answers

• 

  Kishorm Member Posts: 921

  2016-08-30 Answer ✓

  Hi, You need a find('-') for the vle record just after the SETRANGE similar to what you have done for the str record

  1