Single file find

Command groupFlag affectedReversibleExecute on clientPlatform(s)
Finding dataYESYESNOAll

Syntax

Single file find
 
on 
field-name
 
 ([
Exact match
])
 {
calculation
}

Options

Exact matchIf specified,the index value of the field in suitable records must equal the current value

Description

This command locates a record in a single file only. It is similar to the standard Find command but is not dependent on the main file; that is, the field used in Single file find does not have to belong to the main file and it does not read in the connected records. You can specify a calculation for Single file find which determines the value used in the Find. The Exact match option with a blank calculation indicates that the command is to be executed using the current value of the field, that is, the file is searched for a record whose index value matches the current value of the specified field.

In multi-user systems, a Single file find while in Prepare for... mode causes additional semaphores to be set. If the record is already locked, the user must wait for access to the record.

Example

# Find account lMyAccCode

Prompt for input
 
Account Code ?
 
Returns 
lMyAccCode
 (
Cancel button
)

Wait for semaphores
Single file find
 
on 
fAccounts
.
Code
 (
Exact match
)
 {
fAccounts
.
Code
=
lMyAccCode
}

If flag false
  
OK message
 
{
Can't find record
}

End If