AppendMatrixFieldToKeyName
Paul Timms
2017-03-14
In some datadefs, AppendMatrixFieldToKeyName is used to allow searching for a record containing a particular matrix field, without having to loop through the rows. For example, POVc has this index:


SubsetKeyBegin2(ActArtCodeOSFlag);

StoreInBaseKey;
AppendMatrixFieldToKeyName(ArtCode,0);
KeySegment(SerNr);


I have written a procedure which loops through POVc looking for those containing a specific item, but it returns no results even though I have a purchase order with the specified item. Below is the code I am using. Any idea what might be wrong?

TrHs = true;
index = "ActArtCodeOSFlag:" & INr.Code;
ResetLoop(POr);
while (LoopKey(index,POr,1,TrHs)) begin
if (TrHs) then begin

trace(POr.SerNr,POr.TransDate);


Thanks

Paul
Leave Comment
You can subscribe to notifications for this post by selecting the 'star' icon on the top right corner of the post.
Latest Posts
Hi there, I've just tried to get to HansaManuals from my browser only to be given a webpage that says the following: "HansaManuals can only be opened from within Standard ERP. Please o...
13:05 30 Oct 2026
Tatjana Rozentsova
Hi Paul, BackgroundHALShouldPause is a Boolean function with no arguments. - False: keep working. - True: finish the current item safely and exit the routine. It tells a background HAL routine...
14:12 26 Oct 2026