Look

Look can be used to check the existence of data in the database for a condition. It behaves exactly as the Read operations and has the same syntax. The only differences are the following:
* The variables present in the [F] class are not modified.
* Look cannot be used on joins declared with the Link instruction.
* Look does not allow you to know if the record is locked. The only solution is to check the user's Readlock.

After the execution of Look:
* fstat is updated with the same values as Read.
* The current line becomes the line found. Consequently, a Read Curr will fill the [F] record with the result of the line found through the look operation. Note, If Look returns an fstat error, the subsequent Read Curr results are unpredictable.

With SQL server, Look uses a dynamic cursor regardless of whether or not WithStability is specified.

For more information, see the Read document.

See also

Readlock, File, Link, Filter, Columns, For, Rewrite, RewriteByKey, Delete, DeleteByKey, Update, Look, Write, fstat, currind, currlen, With, Stability.