NE (Locate Text)

Summary

The following table summarizes the LOCATE command.

Format	Action	Result
NE /string/	Enter NE in the line number column. Enter the search string in the text entry area of the panel. Use a special character to delimit the search string.	Locates the first occurrence of the string after the line on which you entered the command. Does not find a match on the current line.

Description

Use the NE command to locate character strings by searching forward. Or, you can search backward using the PR (locate previous) command described on a following page. The string size limit is 32 characters.

Action

To search for character strings, issue the command and define the string. You issue the command in the line number column and specify the string in the actual text entry area of the editor panel. Type the search string over existing text. CA Dataquery does not delete the text you type over. Use special characters to delimit the search string. Any special character placed in position 1 (column 1) or the query text line where NE appears in the line number column is interpreted as the string delimiter. For example some special characters are:

? @ # % /

To repeat the search, reenter the command in the line number column. You do not need to reenter the search text.

Example—Locate Next

 =>
 ------------------------------------------------------------------------DQD10
 DATAQUERY:  EDITOR
 -----------------------------------------------------------------------------
 NAME:          SAMPLE                            TYPE: QUERY   STATUS: PRIVATE
 DESCRIPTION:   CHANGE QUERY TEXT__________________________________________
    ....+....1....+....2....+....3....+....4....+....5....+....6....+....7....+.
 .. ================================ T O P =====================================
 NE /ITM-ID/CAI-SLSHST-REC
 02 WITH SHIP-QTY > 100
 03 RELATED BY ITM-ID TO CAI-RCPTS-REC
 04 SET NET-COST (8.2) = CAI-SLSHST-REC SHIP-QTY * UNIT-PRICE
 05 SET DISCOUNT (5.2) = NET-COST * DISC-PCT
 06 SET DISCOUNT-COST (8.2) = NET-COST - DISCOUNT
 07 SORT CAI-RCPTS-REC BY (ITM-ID)
 08 CAI-SLSHST-REC BY (ITM-ID)
 09 PRINT FROM CAI-RCPTS-REC ITM-ID 'ITM-ID'
 10 FROM CAI-SLSHST-REC ITM-ID
 11 SHIP-QTY
 -----------------------------------------------------------------------------
 <PF1>  HELP       <PF2>  RETURN       <PF3>  EXECUTE      <PF4>  SAVE
 <PF5>  DIALOG DEF <PF6>  DELETE       <PF7>  BACKWARD     <PF8>  FORWARD
 <PF9>  UPDATE     <PF10> VALIDATE     <PF11> RIGHT/LEFT   <PF12> CREATE MODE

Result

 =>--------------------------------------------------------------------------DQD10
 DATAQUERY:  EDITOR
 -----------------------------------------------------------------------------
 NAME:          SAMPLE                            TYPE: QUERY   STATUS: PRIVATE
 DESCRIPTION:   LOCATE QUERY TEXT
    ....+....1....+....2....+....3....+....4....+....5....+....6....+....7....+.
 03 RELATED BY ITM-ID TO CAI-RCPTS-REC
 04 SET NET-COST (8.2) = CAI-SLSHST-REC SHIP-QTY * UNIT-PRICE
 05 SET DISCOUNT (5.2) = NET-COST * DISC-PCT
 06 SET DISCOUNT-COST (8.2) = NET-COST - DISCOUNT
 07 SORT CAI-RCPTS-REC BY (ITM-ID)
 08 CAI-SLSHST-REC BY (ITM-ID)
 09 PRINT FROM CAI-RCPTS-REC ITM-ID 'ORD-ID'
 10 FROM CAI-SLSHST-REC ITM-ID
 11 SHIP-QTY
 12 UNIT-PRICE
 13 (NET-COST)
 14 DISCOUNT
 -----------------------------------------------------------------------------
 <PF1>  HELP       <PF2>  RETURN       <PF3>  EXECUTE      <PF4>  SAVE
 <PF5>  DIALOG DEF <PF6>  DELETE       <PF7>  BACKWARD     <PF8>  FORWARD
 <PF9>  UPDATE     <PF10> VALIDATE     <PF11> RIGHT/LEFT   <PF12> CREATE MODE