$Curfile: Difference between revisions

From m204wiki
Jump to navigation Jump to search
No edit summary
Line 1: Line 1:
<p>The $CURFILE function returns the name of the file from which the current record has been selected. If the file is remote, $CURFILE also returns the location of the file (in the form <var class="term">filename AT location</var>). $CURFILE takes no arguments. </p>
<p>The <var>$Curfile</var> function returns the name of the file from which the current record has been selected. If the file is remote, <var>$Curfile</var> also returns the location of the file (in the form <var class="term">filename AT location</var>). <var>$Curfile</var> takes no arguments. </p>
<p>You can use $CURFILE in two places:</p>
<p>You can use <var>$Curfile</var> in two places:</p>
<ul>
<ul>
<li>In arithmetic and PRINT specifications within a record loop </li>
<li>In arithmetic and <var>Print</var> specifications within a record loop </li>
</li>
</li>
<li>In an IN clause to override a default file or group in a STORE RECORD statement </li>
<li>In an <var>In</var> clause to override a default file or group in a <var>Store Record</var> statement </li>
</li>
</li>
</ul>
</ul>
<p>See [[Files, groups, and reference context#$CURFILE and $UPDATE functions|$CURFILE and $UPDATE functions]] for a discussion of default files and for examples of requests using $CURFILE.      </p>
<p>See [[Files, groups, and reference context#$CURFILE and $UPDATE functions|$CURFILE and $UPDATE functions]] for a discussion of default files and for examples of requests using <var>$Curfile</var>.      </p>
<p>You cannot use an IN clause that includes both MEMBER and $CURFILE. See [[Files, groups, and reference context#IN GROUP MEMBER clause|IN GROUP MEMBER clause]] for more information about the IN GROUP MEMBER clause.  </p>
<p>You cannot use an <var>In</var> clause that includes both <var>Member</var> and <var>$Curfile</var>. See [[Files, groups, and reference context#IN GROUP MEMBER clause|IN GROUP MEMBER clause]] for more information about the <var>In Group Member</var>  clause.  </p>
 
==See also==
==See also==
<ul>
<ul>

Revision as of 20:56, 7 April 2015

The $Curfile function returns the name of the file from which the current record has been selected. If the file is remote, $Curfile also returns the location of the file (in the form filename AT location). $Curfile takes no arguments.

You can use $Curfile in two places:

  • In arithmetic and Print specifications within a record loop
  • In an In clause to override a default file or group in a Store Record statement

See $CURFILE and $UPDATE functions for a discussion of default files and for examples of requests using $Curfile.

You cannot use an In clause that includes both Member and $Curfile. See IN GROUP MEMBER clause for more information about the In Group Member clause.

See also

  • The CURFILE parameter.
    Note: In general, $Curfile is better than $View('CURFILE').
  • The DEFCNTX parameter (which is quite similar to CURFILE but provides more information) and the APDFCNTX parameter.
  • The DEFAULT and OPEN commands, which reset the file/group context.
  • The OPENC command does not reset the file/group context.
  • The CLOSE command, which might reset the file/group context.