JAL: typo

2018-04-24T18:49:35Z

typo

← Older revision		Revision as of 18:49, 24 April 2018
Line 1:		Line 1:
	{{Template:M204.0179 skeleton}}		{{Template:M204.0179 skeleton}}
	<P>		<P>
	A <var>[[Find statement (find records)\|Find]]</var> statement or <var>[[IFFIND (HLI ~~funciton~~)\|IFFIND]]</var> function must do a sequential retrieval where indexed retrieval is impossible. A Table B search results. This request would be more efficient if <var class="term">fieldName</var> were <var>KEY</var>, <var>NUMERIC RANGE</var>, or <var>ORDERED</var>, depending upon the context. </P>		A <var>[[Find statement (find records)\|Find]]</var> statement or <var>[[IFFIND (HLI function)\|IFFIND]]</var> function must do a sequential retrieval where indexed retrieval is impossible. A Table B search results. This request would be more efficient if <var class="term">fieldName</var> were <var>KEY</var>, <var>NUMERIC RANGE</var>, or <var>ORDERED</var>, depending upon the context. </P>
	<P>		<P>
	The possible <var>Find</var> statement contexts producing this message are: </P>		The possible <var>Find</var> statement contexts producing this message are: </P>

DmeWiccan: Automatically generated page update

2018-02-14T12:45:12Z

Automatically generated page update

New page

{{Template:M204.0179 skeleton}}

A <var>[[Find statement (find records)|Find]]</var> statement or <var>[[IFFIND (HLI funciton)|IFFIND]]</var> function must do a sequential retrieval where indexed retrieval is impossible. A Table B search results. This request would be more efficient if <var class="term">fieldName</var> were <var>KEY</var>, <var>NUMERIC RANGE</var>, or <var>ORDERED</var>, depending upon the context. 

The possible <var>Find</var> statement contexts producing this message are: 
<ul>
<li><var class="term">fieldName</var> = <var class="term">value</var>, where <var class="term">fieldName</var> is <var>NON-KEY</var> </li>

<li><var class="term">fieldName</var> IS <var class="term">value</var> or IS GREATER THAN <var class="term">value</var> or IS LESS THAN <var class="term">value</var>, where <var class="term">fieldName</var> is <var>NON-RANGE</var> </li>

<li><var class="term">fieldName</var> IS BETWEEN <var class="term">value1</var> AND <var class="term">value2</var>, where <var class="term">fieldName</var> is <var>NON-RANGE</var> </li>

<li><var class="term">fieldName</var> IS AFTER <var class="term">value</var> or IS BEFORE <var class="term">value</var>, for any type of field </li>

<li><var class="term">fieldName</var> IS PRESENT, for any type of field </li>
<li><var class="term">fieldName</var> IS ALPHA ... <var class="term">value</var>, for an <var>ORDERED NUMERIC</var> field </li>
<li><var class="term">fieldName</var> IS NUM ... <var class="term">value</var>, for an <var>ORDERED CHARACTER</var> field </li>
</ul>

Response: For those fields where <var>IS ALPHA</var> was specified for an <var>ORDERED NUMERIC</var> field, change <code>IS ALPHA</code> to <code>IS NUM</code>, and the same applies to fields defined as <var>ORDERED CHARACTER</var> where <var>IS NUM</var> was used. 

File manager response: If several of these messages appear for a given field name, consider using the <var>REDEFINE</var> command making the field <var>KEY</var>, <var>NUMERIC RANGE</var>, or <var>ORDERED</var>. 
{{Template:M204.0179 footer}}

M204.0179 - Revision history

JAL: typo

DmeWiccan: Automatically generated page update