Searching data

You can search indexed and non-indexed tables to find records that match your specified criteria.

Note

All search options are case-sensitive.

To search data:

  1. Select Data > Search.
  2. If you are searching a table that does not have an index, do one of the following:
    • Select Locate Record to find a specific record number in the table.

    • Select Locate If to find the first record in the table that meets a specified condition. The condition can be a specified string.

  3. If you are searching an indexed table, do one of the following:
    • Select Locate Record to find a specific record number in the table.

    • Select Locate If to find the first record in the table that meets a specified condition. The condition can be a specified string.

    • Select Find Literal to locate the first record that has a value in the index key field equal to or greater than a specified value.

    • Select Seek Expression to locate the first record that has a value in the index key field equal to or greater than a specified character-type expression, or that matches a specified string.

  4. If you selected Locate Record, Locate If, or Seek Expression, do one of the following:
    • In the Expr text box, type the record number, expression, or string to search for.

      To use Locate If to find a string you must build an appropriate expression, such as prod_desc = “plywood”.

      To use Seek Expression to find a string, enter the full or partial string surrounded by quotation marks directly in the Expr text box – for example, “plywood”. Leading blanks can be used after the opening quotation mark.

    • Click Expr to create an expression.

  5. If you selected Find Literal, enter the full or partial string directly in the Expr text box. Do not put quotation marks around the string – for example, plywood.
  6. Click OK.
Related concepts
About searching data


(C) 2013 ACL Services Ltd. All Rights Reserved. | Send feedback