Shareware Overload/ShartewareOverload.cdr/database/workdb.zip/SEARCH.PRG

Text File | 1988-08-15 | 4KB | 136 lines

*!!* dBASE CONVERT - dBASE III File Conversion Aid  v2.01  1/10/86
*
SET HEADING OFF
SET SAFETY OFF
* search.sig 08/18/83
* index search program with ability to edit, delete, print, print voucher

STORE .T. TO FIRST

STORE .T. TO MORE
DO WHILE MORE
   IF FIRST
      STORE CHR(PEEK (063)) TO dr
      USE &DR.:SIG/M INDEX &DR.:ORDERS
      CLEAR
      STORE 'SEARCH FOR RECORD BY <L>AST NAME OR <A>NY PART OF DATA BASE' TO PROMPT1
      STORE '<B>ACKWARD OR <F>ORWARD, <D>ELETE/RECALL, <E>DIT' TO PROMPT2
      STORE '<P>RINT, <V>OUCHER OR <Q>UIT SEARCHING' TO PROMPT3
      STORE  'RECORD SEARCH MODULE' TO MODE
      @  1,25 SAY MODE
      @  2, 0 SAY "+--------------------------------------"
      @  2,39 SAY "----------------------------------------+"
      @  3, 5 SAY "ORDER NUMBER:"
      @  3,43 SAY "Complete:"
      @  4, 8 SAY "Last name:"
      @  4,46 SAY "First:"
      @  5,10 SAY "Address:"
      @  6, 9 SAY "(line 2):"
      @  7, 9 SAY "(line 3):"
      @  8,13 SAY "City:"
      @  8,46 SAY "State:"
      @  8,65 SAY "ZIP:"
      @ 10, 2 SAY "Volumes:"
      @ 12, 3 SAY "Amount:"
      @ 12,46 SAY "Enter:"
      @ 12,64 SAY "Ship:"
      @ 13, 2 SAY "Remarks:"
      @ 14, 2 SAY "Remarks:"
      @ 16, 0 SAY "Backorder:"
      @ 17,44 SAY "Catalog:"
      @ 18, 2 SAY "Shipped:"
      @ 18,26 SAY "Shipped:"
      @ 18,62 SAY "Update:"
      @ 19, 0 SAY "+--------------------------------------"
      @ 19,39 SAY "----------------------------------------+"
      @ 20,12 SAY PROMPT1
      @ 21,12 SAY PROMPT2
      @ 22,12 SAY PROMPT3
   ENDIF FIRST
   STORE .F. TO FIRST
   STORE 'L' TO COMMAND
   STORE '                     ' TO NAME
   IF DELETE()
      STORE 'DELETED' TO DELETED
   ELSE
      STORE '       ' TO DELETED
   ENDIF *
   @  1, 0 SAY DELETED
   @  3,19 SAY ORDER
   @  3,53 SAY COMP
   @  4,19 SAY LNAME
   @  4,53 SAY FNAME
   @  5,19 SAY ADDR1
   @  6,19 SAY ADDR2
   @  7,19 SAY ADDR3
   @  8,19 SAY CITY
   @  8,53 SAY STATE
   @  8,70 SAY ZIP
   @ 10,11 SAY VOL1
   @ 12,11 SAY AMT PICTURE '$###.##'
   @ 12,53 SAY ENTERED
   @ 12,70 SAY SHIPPED
   @ 13,11 SAY REM1
   @ 14,11 SAY REM2
   @ 16,11 SAY BO
   @ 17,53 SAY CATALOG
   @ 18,11 SAY BO_SHIP
   @ 18,35 SAY BO2_SHIP
   @ 18,70 SAY DAYU
   @ 22,56 SAY 'WHAT NEXT?'
   @ 22,70 GET COMMAND PICTURE '!'
   READ
   CLEAR GETS
   DO CASE
      CASE COMMAND = 'A'
           DO SEARCH1.PRG
      CASE (command = 'B' .OR. command = ',')
           SKIP -1
      CASE COMMAND = 'D'
           IF DELETE()
              RECALL
           ELSE
              DELETE
           ENDIF
      CASE (command = 'F' .OR. command = '.')
           SKIP
      CASE COMMAND = 'E'
           DO EDIT.PRG
      CASE COMMAND = 'P'
           DO PRINT.PRG
      CASE COMMAND = 'V'
           DO VOUCHER.PRG
      CASE COMMAND = 'L'
           STORE RECNO() TO rec_number
           @ 20,00
           @ 21,00
           @ 22,00
           @ 20,12 SAY 'PLEASE ENTER LAST NAME' GET NAME
           READ
           STORE TRIM(name) TO name
           STORE UPPER(name) TO name
           *!! EOF() will be true if NO FIND, and RECNO() will equal BOTTOM, not 0.
           FIND &NAME
           @ 20,12 SAY '                                                           '
           IF (EOF() .OR. BOF())
              @ 20,00
              @ 20,12 SAY NAME+' IS NOT IN THE FILE'
              @ 21,12 SAY 'PRESS RETURN TO CONTINUE'
              SET CONSOLE OFF
              WAIT
              SET CONSOLE ON
              GOTO REC_NUMBER
              @ 20,00
              @ 21,12 SAY '                                                           '
           ENDIF #=0
           @ 20,12 SAY PROMPT1
           @ 21,12 SAY PROMPT2
           @ 22,12 SAY PROMPT3
      CASE COMMAND = 'Q'
           STORE  .F.  TO MORE
   ENDCASE
ENDDO WHILE MORE
RELEASE ALL
STORE .T. TO FIRST