JAL: add `'s`

2018-03-07T23:56:51Z

add <var>'s

← Older revision		Revision as of 23:56, 7 March 2018
Line 1:		Line 1:
	{{Template:M204.1528 skeleton}}		{{Template:M204.1528 skeleton}}
	<P>		<P>
	A <code>~~FOR EACH RECORD IN~~ <i>label</i> ~~WHERE~~/~~WITH~~</code> statement refers to the result of a ~~SORT RECORDS~~ statement. The ~~WHERE~~/~~WITH~~ clause is valid only when the ~~FOR~~ statement refers to a ~~FIND~~ statement or to a ~~LIST~~. </P>		A <code>For Each Record In <i>label</i> Where/With</code> statement refers to the result of a <var>Sort Records</var> statement. The <var>Where/With</var> clause is valid only when the <var>For</var> statement refers to a <var>Find</var> statement or to a <var>List</var>. </P>
	<p>		<p>
	<b>Response:</b> Correct the program by adding the ~~WHERE~~/~~WITH~~ clause to a ~~FIND~~ statement and referring the ~~SORT~~ statement to the new ~~FIND~~ statement, or by placing the conditions in the ~~WHERE~~/~~WITH~~ clause in an IF statement inside the		<b>Response:</b> Correct the program by adding the <var>Where/With</var> clause to a <var>Find</var> statement and referring the <var>Sort</var> statement to the new <var>Find</var> statement, or by placing the conditions in the <var>Where/With</var> clause in an <var>If</var> statement inside the <var>For Each Record</var> loop.
	~~FOR EACH RECORD~~ loop. </p>		</p>
	{{Template:M204.1528 footer}}		{{Template:M204.1528 footer}}
	<!-- skeleton as it was in pdf/WHERE/WITH CLAUSE IS INVALID AGAINST SORTED SET /-->		<!-- skeleton as it was in pdf/WHERE/WITH CLAUSE IS INVALID AGAINST SORTED SET /-->

DmeWiccan: Automatically generated page update

2018-03-07T15:32:16Z

Automatically generated page update

New page

{{Template:M204.1528 skeleton}}

A <code>FOR EACH RECORD IN label WHERE/WITH</code> statement refers to the result of a SORT RECORDS statement. The WHERE/WITH clause is valid only when the FOR statement refers to a FIND statement or to a LIST. 

Response: Correct the program by adding the WHERE/WITH clause to a FIND statement and referring the SORT statement to the new FIND statement, or by placing the conditions in the WHERE/WITH clause in an IF statement inside the
FOR EACH RECORD loop. 
{{Template:M204.1528 footer}}

M204.1528 - Revision history

JAL: add 's

DmeWiccan: Automatically generated page update

JAL: add `'s`