AppendMatrixFieldToKeyName
Paul Timms
3-14-17
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
Andis Blicāns, Grasko
Hello! Does anyone have a complete list of parameters that can be used in the "parameters.txt" file? If so, I would be grateful if you could send them to me at andis.blicans@gmail.com...
15:04 2 Aug 2026
Bror-Erik Kotiranta
So the mystandard have gotten a face lift. So when the backup is triggered, thats the time when a "snapshot" is taken from the system and written down to the backup (.TXT file)...
14:10 20 July 2026