https://m204wiki.rocketsoftware.com/index.php?action=history&feed=atom&title=M204.1687 2026-04-09T00:29:12Z Revision history for this page on the wiki MediaWiki 1.43.1 https://m204wiki.rocketsoftware.com/index.php?title=M204.1687&diff=109478&oldid=prev 2018-03-07T15:53:40Z

<p>Automatically generated page update</p> <p><b>New page</b></p><div>{{Template:M204.1687 skeleton}}<br /> &lt;P&gt;<br /> A field name variable (%%&lt;i&gt;fieldname&lt;/i&gt;) was executed in a &lt;code&gt;For Each Record In Order By %%&lt;i&gt;fieldname&lt;/i&gt;&lt;/code&gt; statement, and the &lt;var class=&quot;term&quot;&gt;%fieldname&lt;/var&gt; contains the name of a &lt;var&gt;NONORDERED&lt;/var&gt; field. The &lt;var&gt;In Order By&lt;/var&gt; clause cannot be used with &lt;var&gt;NONORDERED&lt;/var&gt; fields. &lt;/P&gt;<br /> &lt;p&gt;<br /> &lt;b&gt;Response:&lt;/b&gt; The &lt;var&gt;Sort Records&lt;/var&gt; statement must be used to order records by a &lt;var&gt;NONORDERED&lt;/var&gt; non-&lt;var&gt;SORT&lt;/var&gt; &lt;var&gt;KEY&lt;/var&gt; field. Correct the program to use the &lt;var&gt;Sort&lt;/var&gt; statement if ordering by a &lt;var&gt;NONORDERED&lt;/var&gt; field is required. &lt;/p&gt;<br /> &lt;p&gt;<br /> &lt;b&gt;File manager response:&lt;/b&gt; Consider making the field &lt;var&gt;ORDERED&lt;/var&gt;, since &lt;var&gt;For Each Record In Order By&lt;/var&gt; may be more efficient than the &lt;var&gt;Sort Records&lt;/var&gt; statement. &lt;/p&gt;<br /> {{Template:M204.1687 footer}}<br /> &lt;!-- skeleton as it was in pdf/FNV ON ORDERED FOR LOOP WAS NOT AN ORDERED FIELD. FIELD = field /--&gt;</div>

DmeWiccan