Problems reading specific Record from a Table / Navision 4.0

aod

I want to get an other record from the Sales Shipment Line in the Report "Delivery Note". I created a new Key containing the 3 Fields Document No., Position & Type. I created an new Global in the Report calles ShipLine. And using the Following Code:

ShipLine.setcurrentkey ("Document No.","Position","Type");
If ShipLine.Get ("Document No.","Position",Type::Item) THEN;

I get the Error Message :

"Too many Key Fields where specified, so Sales Shipment Line could not be retrieved. The number of Fields in Primary Key is 2."

What I am doing wrong ?

Luc_VanDyck

GET always works with the primary key. It does not use the key you selected with SETCURRENTKEY. And the primary key of Sales Shipment Line is "Document No.,Line No.", so it expects only 2 fields.

Otherwise you need to write your code like this:

ShipLine.SETCURRENTKEY("Document No.","Position","Type"); 
ShipLine.SETRANGE("Document No.","Document No.");
ShipLine.SETRANGE(Position,Position);
ShipLine.SETRANGE(Type,ShipLine.Type::Item);
IF ShipLine.FIND('-') THEN;

aod

Big THX for fast Answer and the very good explaination !

I will try it as soon as possible.

garak

"Get" ever use the primary key. When yoe will use an secondary key, you must use setfilter / setrange and find.

Regards

kriki

garak wrote:

"Get" ever use the primary key. When yoe will use an secondary key, you must use setfilter / setrange and find.

Regards

Always try to use SETRANGE. It is potentially faster than a SETFILTER.

A good programming practice is:

recMyRecord.RESET;
recMyRecord.SETCURRENTKEY("My Key"); // even if it is the primary key
recMyRecord.SETRANGE(...);
recMyRecord.SETRANGE(...);
recMyRecord.SETRANGE(...);
recMyRecord.SETFILTER(...); // if you can't use a SETRANGE
IF recMyRecord.FIND('-') THEN
  REPEAT

  UNTIL recMyRecord.NEXT = 0;

or in case you don't want to loop the records:

IF recMyRecord.FIND('-') THEN ...

or even better in 4.00SP1:

IF recMyRecord.FINDFIRST THEN ...