home *** CD-ROM | disk | FTP | other *** search
/ Shareware Overload / ShartewareOverload.cdr / database / prg_hlp.zip / MENU2.PRG < prev    next >
Text File  |  1987-04-07  |  40KB  |  1,170 lines

  1. ************************************************************************
  2. *
  3. *                         MENU2.PRG                                   *
  4. *
  5. ************************************************************************
  6. DO WHILE .T.
  7.    CLEAR
  8.    DO WHILE .T.
  9.       help_code = "02"
  10.       A = "MENU2"
  11.       DO banner WITH "AUDIO MENU"
  12.       heading1 = "1. ENTER TITLES       "
  13.       heading2 = "2. SEARCH TITLES      "
  14.       heading3 = "3. EDIT TITLES        "
  15.       heading4 = "4. NOT COMPLETED      "
  16.       heading5 = "0. MAIN MENU          "
  17.       heading6 = "XXXX"
  18.       heading7 = "XXXX"
  19.       heading8 = "XXXX"
  20.       heading9 = "XXXX"
  21.       heading10 = "XXXX"
  22.       num_items = 5
  23.       X = 8
  24.       Y = 28
  25.       W = LEN(heading3)
  26.       @ 0,0 to 24,79 double
  27.       DO F1 WITH "HELP"
  28.       @ 22,1 SAY bar
  29.       @ 23,2 SAY "Use UP and DOWN arrows to highlight choice...Press ENTER to select"
  30.       DO lightbar WITH num_items,X,Y,W,heading1,heading2,heading3,heading4,heading5,heading6,heading7,heading8,heading9,heading10
  31.       choice = STR(selection,1)
  32.       use audio index a_title, a_artist
  33.       DO CASE
  34.       CASE choice = "1"
  35.          DO aud_ent
  36.       CASE choice = "2"
  37.          do aud_srch
  38.       CASE choice = "3"
  39.          do aud_edit
  40.       CASE choice = "4"
  41.          do aud_set
  42.       CASE choice = "0"
  43.          RETURN
  44.       ENDCASE
  45.    ENDDO
  46. ENDDO
  47. **************************  END AUDIO.PRG  *******************
  48. **********************************************************************
  49. *                                                                    *
  50. *                       S. Robert Davidoff                           *
  51. *                                                                    *
  52. *                                                                    *
  53. **********************************************************************
  54. *                          AUD_EDIT.PRG
  55. **********************************************************************
  56.  
  57.  
  58. procedure aud_edit
  59. do while .T.
  60.    use audio index a_title, a_artist
  61.    clear
  62.    do banner with "EDIT AUDIO INFORMATION"
  63.    @ 0,0 to 24,79 double
  64.    do while .T.
  65.       heading1 = "1. FIND TITLE "
  66.       heading2 = "2. FIND ARTIST"
  67.       heading3 = "0. MAIN MENU  "
  68.       heading4 = "XXXX"
  69.       heading5 = "XXXX"
  70.       heading6 = "XXXX"
  71.       heading7 = "XXXX"
  72.       heading8 = "XXXX"
  73.       heading9 = "XXXX"
  74.       heading0 = "XXXX"
  75.       num_items = 3
  76.       X = 7
  77.       Y =27
  78.       W = LEN(HEADING1)
  79.       @ 22,1 say bar
  80.       @ 23,2 say "Use UP and DOWN arrows to highlight choice...Press ENTER to select"
  81.       do lightbar with num_items,X,Y,W,heading1,heading2,heading3,heading4,heading5,heading6,heading7,heading8,heading9,heading0
  82.       choice = str(selection,1)
  83.       DO case
  84.       case choice = "0"
  85.          return
  86.       case choice = "1"
  87.          HELP_CODE = "AT"
  88.          set order to 1
  89.          goto top
  90.          mtitle = space(35)
  91.          do clearit with 1,1,23,78
  92.          @ 8,20 say "Enter Title: " get mtitle Picture "@!"
  93.          DO F1 WITH "HELP"
  94.          read
  95.          row = 1
  96.          mtitle = alltrim(mtitle)
  97.          mtemp = mtitle
  98.          seek mtitle
  99.          if eof()
  100.             goto top
  101.             do while ! eof()
  102.                if AT(mtemp,title) > 0
  103.                   do clearit with 1,1,23,78
  104.                   do while ! eof()
  105.                      mtitle = title
  106.                      mlastname = lastname
  107.                      mfirstname = firstname
  108.                      mmedium = medium
  109.                      mtype = type
  110.                      mcat = cat
  111.                      answer = space(1)
  112.                      @ 7,10 say "Enter Title: "
  113.                      @ 7,33 get mtitle Picture "@!"
  114.                      @ 9,10 say "Enter Last Name: "
  115.                      @ 9,33 get mlastname Picture "@!"
  116.                      @ 11,10 say "Enter First Name: "
  117.                      @ 11,33 get mfirstname Picture "@!"
  118.                      @ 13,10 say "T)ape   R)ecord  C)ompact disk "
  119.                      @ 13,48 get mmedium picture "!" valid (mmedium $ "TRC")
  120.                      @ 15,10 say "I)nstramental   V)ocal   M)ixed "
  121.                      @ 15,48 get mtype picture "!" valid (mtype $ "IVM")
  122.                      @ 17,10 say "J)azz   C)lassic   M)ellow "
  123.                      @ 17,48 get mcat picture "!" valid (mcat $ "JCM")
  124.                      do f1 with "HELP"
  125.                      @ 0,0 to 24,79 double
  126.                      read
  127.                      MSG1 = "1. FILE  "
  128.                      MSG2 = "2. EDIT  "
  129.                      MSG3 = "3. NEXT  "
  130.                      MSG4 = "4. DELETE"
  131.                      MSG5 = "0. ABORT "
  132.                      MSG6 = "XXXX"
  133.                      MSG7 = "XXXX"
  134.                      MSG8 = "XXXX"
  135.                      MSG9 = "XXXX"
  136.                      MSG0 = "XXXX"
  137.                      NUM_ITEMS = 5
  138.                      X = 23
  139.                      Y = 1
  140.                      W = LEN(MSG1)
  141.                      MSTRING = "FENDA"
  142.                      DO CLEARIT WITH X-1,Y,X,78
  143.                      @ X-1,1 SAY BAR
  144.                      DO H_LIGHT WITH NUM_ITEMS,X,Y,W,MSG1,MSG2,MSG3,MSG4,MSG5,MSG6,MSG7,MSG8,MSG9,MSG0,MSTRING
  145.                      ANSWER = STR(SELECTION,1)
  146.                      do case
  147.                      case answer = "0"
  148.                         return
  149.                      case answer = "1"
  150.                         
  151.                      case answer = "2"
  152.                         do clearit with 21,1,23,78
  153.                         loop
  154.                      case answer = "4"
  155.                         delete
  156.                         skip
  157.                         do clearit with 21,1,23,78
  158.                         loop
  159.                      case answer = "3"
  160.                         skip
  161.                         do clearit with 21,1,23,78
  162.                         loop
  163.                      endcase
  164.                      replace title with mtitle
  165.                      replace lastname with mlastname
  166.                      replace firstname with mfirstname
  167.                      replace medium with mmedium
  168.                      replace type with mtype
  169.                      replace cat with mcat
  170.                      do clearit with 21,1,23,78
  171.                      Answer = space(1)
  172.                      MSG1 = "1. NEXT RECORD"
  173.                      MSG2 = "0. MAIN MENU  "
  174.                      MSG3 = "XXXX"
  175.                      MSG4 = "XXXX"
  176.                      MSG5 = "XXXX"
  177.                      MSG6 = "XXXX"
  178.                      MSG7 = "XXXX"
  179.                      MSG8 = "XXXX"
  180.                      MSG9 = "XXXX"
  181.                      MSG0 = "XXXX"
  182.                      NUM_ITEMS = 2
  183.                      X = 23
  184.                      Y = 1
  185.                      W = LEN(MSG1)
  186.                      MSTRING = "NM"
  187.                      DO CLEARIT WITH X-1,Y,X,78
  188.                      @ X-1,1 SAY BAR
  189.                      DO H_LIGHT WITH NUM_ITEMS,X,Y,W,MSG1,MSG2,MSG3,MSG4,MSG5,MSG6,MSG7,MSG8,MSG9,MSG0,MSTRING
  190.                      CHOICE = STR(SELECTION,1)
  191.                      if CHOICE = "0"
  192.                         return
  193.                      else
  194.                         do clearit with 21,1,23,78
  195.                         exit
  196.                      endif
  197.                   enddo
  198.                endif
  199.                skip
  200.             enddo
  201.             
  202.             
  203.          else
  204.             do clearit with 1,1,23,78
  205.             do while .T.
  206.                mtitle = title
  207.                mlastname = lastname
  208.                mfirstname = firstname
  209.                mmedium = medium
  210.                mtype = type
  211.                mcat = cat
  212.                
  213.                answer = space(1)
  214.                @ 7,10 say "Enter Title: "
  215.                @ 7,33 get mtitle Picture "@!"
  216.                @ 9,10 say "Enter Last Name: "
  217.                @ 9,33 get mlastname Picture "@!"
  218.                @ 11,10 say "Enter First Name: "
  219.                @ 11,33 get mfirstname Picture "@!"
  220.                @ 13,10 say "T)ape   R)ecord  C)ompact disk "
  221.                @ 13,48 get mmedium picture "!" valid (mmedium $ "TRC")
  222.                @ 15,10 say "I)nstramental   V)ocal   M)ixed "
  223.                @ 15,48 get mtype picture "!" valid (mtype $ "IVM")
  224.                @ 17,10 say "J)azz   C)lassic   M)ellow "
  225.                @ 17,48 get mcat picture "!" valid (mcat $ "JCM")
  226.                do f1 with "HELP"
  227.                @ 0,0 to 24,79 double
  228.                read
  229.                MSG1 = "1. FILE  "
  230.                MSG2 = "2. EDIT  "
  231.                MSG3 = "3. NEXT  "
  232.                MSG4 = "4. DELETE"
  233.                MSG5 = "0. ABORT "
  234.                MSG6 = "XXXX"
  235.                MSG7 = "XXXX"
  236.                MSG8 = "XXXX"
  237.                MSG9 = "XXXX"
  238.                MSG0 = "XXXX"
  239.                NUM_ITEMS = 5
  240.                X = 23
  241.                Y = 1
  242.                W = LEN(MSG1)
  243.                MSTRING = "FENDA"
  244.                DO CLEARIT WITH X-1,Y,X,78
  245.                @ X-1,1 SAY BAR
  246.                DO H_LIGHT WITH NUM_ITEMS,X,Y,W,MSG1,MSG2,MSG3,MSG4,MSG5,MSG6,MSG7,MSG8,MSG9,MSG0,MSTRING
  247.                ANSWER = STR(SELECTION,1)
  248.                do case
  249.                case answer = "0"
  250.                   return
  251.                case answer = "1"
  252.                   
  253.                case answer = "2"
  254.                   do clearit with 21,1,23,78
  255.                   loop
  256.                case answer = "4"
  257.                   delete
  258.                   skip
  259.                   do clearit with 21,1,23,78
  260.                   loop
  261.                case answer = "3"
  262.                   skip
  263.                   do clearit with 21,1,23,78
  264.                   loop
  265.                endcase
  266.                replace title with mtitle
  267.                replace lastname with mlastname
  268.                replace firstname with mfirstname
  269.                replace medium with mmedium
  270.                replace type with mtype
  271.                replace cat with mcat
  272.                do clearit with 21,1,23,78
  273.                Answer = space(1)
  274.                MSG1 = "1. NEXT RECORD"
  275.                MSG2 = "0. MAIN MENU  "
  276.                MSG3 = "XXXX"
  277.                MSG4 = "XXXX"
  278.                MSG5 = "XXXX"
  279.                MSG6 = "XXXX"
  280.                MSG7 = "XXXX"
  281.                MSG8 = "XXXX"
  282.                MSG9 = "XXXX"
  283.                MSG0 = "XXXX"
  284.                NUM_ITEMS = 2
  285.                X = 23
  286.                Y = 1
  287.                W = LEN(MSG1)
  288.                MSTRING = "NM"
  289.                DO CLEARIT WITH X-1,Y,X,78
  290.                @ X-1,1 SAY BAR
  291.                DO H_LIGHT WITH NUM_ITEMS,X,Y,W,MSG1,MSG2,MSG3,MSG4,MSG5,MSG6,MSG7,MSG8,MSG9,MSG0,MSTRING
  292.                CHOICE = STR(SELECTION,1)
  293.                if CHOICE = "0"
  294.                   return
  295.                endif
  296.                do clearit with 21,1,23,78
  297.                skip
  298.             enddo
  299.             @ 23,5 say "Press any key to proceed"
  300.             set console off
  301.             wait
  302.             set console on
  303.          endif
  304.          **********************************************************************
  305.       case choice = "2"
  306.          set order to 2
  307.          goto top
  308.          mlastname = space(25)
  309.          do clearit with 1,1,23,78
  310.          @ 8,20 say "Enter LastName: " get mLastName Picture "@!"
  311.          DO F1 WITH "HELP"
  312.          read
  313.          row = 1
  314.          mLastName = alltrim(mLastName)
  315.          mtemp = mlastname
  316.          seek mLastName
  317.          if eof()
  318.             goto top
  319.             do while ! eof()
  320.                if AT(mtemp,LastName) > 0
  321.                   do clearit with 1,1,23,78
  322.                   do while ! eof()
  323.                      mtitle = title
  324.                      mlastname = lastname
  325.                      mfirstname = firstname
  326.                      mmedium = medium
  327.                      mtype = type
  328.                      mcat = cat
  329.                      answer = space(1)
  330.                      @ 7,10 say "Enter Title: "
  331.                      @ 7,33 get mtitle Picture "@!"
  332.                      @ 9,10 say "Enter Last Name: "
  333.                      @ 9,33 get mlastname Picture "@!"
  334.                      @ 11,10 say "Enter First Name: "
  335.                      @ 11,33 get mfirstname Picture "@!"
  336.                      @ 13,10 say "T)ape   R)ecord  C)ompact disk "
  337.                      @ 13,48 get mmedium picture "!" valid (mmedium $ "TRC")
  338.                      @ 15,10 say "I)nstramental   V)ocal   M)ixed "
  339.                      @ 15,48 get mtype picture "!" valid (mtype $ "IVM")
  340.                      @ 17,10 say "J)azz   C)lassic   M)ellow "
  341.                      @ 17,48 get mcat picture "!" valid (mcat $ "JCM")
  342.                      do f1 with "LIST ENTRIES"
  343.                      @ 0,0 to 24,79 double
  344.                      read
  345.                      MSG1 = "1. FILE  "
  346.                      MSG2 = "2. EDIT  "
  347.                      MSG3 = "3. NEXT  "
  348.                      MSG4 = "4. DELETE"
  349.                      MSG5 = "0. ABORT "
  350.                      MSG6 = "XXXX"
  351.                      MSG7 = "XXXX"
  352.                      MSG8 = "XXXX"
  353.                      MSG9 = "XXXX"
  354.                      MSG0 = "XXXX"
  355.                      NUM_ITEMS = 5
  356.                      X = 23
  357.                      Y = 1
  358.                      W = LEN(MSG1)
  359.                      MSTRING = "FENDA"
  360.                      DO CLEARIT WITH X-1,Y,X,78
  361.                      @ X-1,1 SAY BAR
  362.                      DO H_LIGHT WITH NUM_ITEMS,X,Y,W,MSG1,MSG2,MSG3,MSG4,MSG5,MSG6,MSG7,MSG8,MSG9,MSG0,MSTRING
  363.                      ANSWER = STR(SELECTION,1)
  364.                      do case
  365.                      case answer = "0"
  366.                         return
  367.                      case answer = "1"
  368.                         
  369.                      case answer = "2"
  370.                         do clearit with 21,1,23,78
  371.                         loop
  372.                      case answer = "4"
  373.                         delete
  374.                         skip
  375.                         do clearit with 21,1,23,78
  376.                         loop
  377.                      case answer = "3"
  378.                         skip
  379.                         do clearit with 21,1,23,78
  380.                         loop
  381.                      endcase
  382.                      replace title with mtitle
  383.                      replace lastname with mlastname
  384.                      replace firstname with mfirstname
  385.                      replace medium with mmedium
  386.                      replace type with mtype
  387.                      replace cat with mcat
  388.                      do clearit with 21,1,23,78
  389.                      Answer = space(1)
  390.                      MSG1 = "1. NEXT RECORD"
  391.                      MSG2 = "0. MAIN MENU  "
  392.                      MSG3 = "XXXX"
  393.                      MSG4 = "XXXX"
  394.                      MSG5 = "XXXX"
  395.                      MSG6 = "XXXX"
  396.                      MSG7 = "XXXX"
  397.                      MSG8 = "XXXX"
  398.                      MSG9 = "XXXX"
  399.                      MSG0 = "XXXX"
  400.                      NUM_ITEMS = 2
  401.                      X = 23
  402.                      Y = 1
  403.                      W = LEN(MSG1)
  404.                      MSTRING = "NM"
  405.                      DO CLEARIT WITH X-1,Y,X,78
  406.                      @ X-1,1 SAY BAR
  407.                      DO H_LIGHT WITH NUM_ITEMS,X,Y,W,MSG1,MSG2,MSG3,MSG4,MSG5,MSG6,MSG7,MSG8,MSG9,MSG0,MSTRING
  408.                      CHOICE = STR(SELECTION,1)
  409.                      if CHOICE = "0"
  410.                         return
  411.                      else
  412.                         do clearit with 21,1,23,78
  413.                         exit
  414.                      endif
  415.                   enddo
  416.                endif
  417.                skip
  418.             enddo
  419.          else
  420.             do clearit with 1,1,23,78
  421.             do while .T.
  422.                mtitle = title
  423.                mlastname = lastname
  424.                mfirstname = firstname
  425.                mmedium = medium
  426.                mtype = type
  427.                mcat = cat
  428.                answer = space(1)
  429.                @ 7,10 say "Enter Title: "
  430.                @ 7,33 get mtitle Picture "@!"
  431.                @ 9,10 say "Enter Last Name: "
  432.                @ 9,33 get mlastname Picture "@!"
  433.                @ 11,10 say "Enter First Name: "
  434.                @ 11,33 get mfirstname Picture "@!"
  435.                @ 13,10 say "T)ape   R)ecord  C)ompact disk "
  436.                @ 13,48 get mmedium picture "!" valid (mmedium $ "TRC")
  437.                @ 15,10 say "I)nstramental   V)ocal   M)ixed "
  438.                @ 15,48 get mtype picture "!" valid (mtype $ "IVM")
  439.                @ 17,10 say "J)azz   C)lassic   M)ellow "
  440.                @ 17,48 get mcat picture "!" valid (mcat $ "JCM")
  441.                do f1 with "HELP"
  442.                @ 0,0 to 24,79 double
  443.                read
  444.                MSG1 = "1. FILE  "
  445.                MSG2 = "2. EDIT  "
  446.                MSG3 = "3. NEXT  "
  447.                MSG4 = "4. DELETE"
  448.                MSG5 = "0. ABORT "
  449.                MSG6 = "XXXX"
  450.                MSG7 = "XXXX"
  451.                MSG8 = "XXXX"
  452.                MSG9 = "XXXX"
  453.                MSG0 = "XXXX"
  454.                NUM_ITEMS = 5
  455.                X = 23
  456.                Y = 1
  457.                W = LEN(MSG1)
  458.                MSTRING = "FENDA"
  459.                DO CLEARIT WITH X-1,Y,X,78
  460.                @ X-1,1 SAY BAR
  461.                DO H_LIGHT WITH NUM_ITEMS,X,Y,W,MSG1,MSG2,MSG3,MSG4,MSG5,MSG6,MSG7,MSG8,MSG9,MSG0,MSTRING
  462.                ANSWER = STR(SELECTION,1)
  463.                do case
  464.                case answer = "0"
  465.                   return
  466.                case answer = "1"
  467.                   
  468.                case answer = "2"
  469.                   do clearit with 21,1,23,78
  470.                   loop
  471.                case answer = "4"
  472.                   delete
  473.                   skip
  474.                   do clearit with 21,1,23,78
  475.                   loop
  476.                case answer = "3"
  477.                   skip
  478.                   do clearit with 21,1,23,78
  479.                   loop
  480.                endcase
  481.                replace title with mtitle
  482.                replace lastname with mlastname
  483.                replace firstname with mfirstname
  484.                replace medium with mmedium
  485.                replace type with mtype
  486.                replace cat with mcat
  487.                do clearit with 21,1,23,78
  488.                MSG1 = "1. NEXT RECORD"
  489.                MSG2 = "0. MAIN MENU  "
  490.                MSG3 = "XXXX"
  491.                MSG4 = "XXXX"
  492.                MSG5 = "XXXX"
  493.                MSG6 = "XXXX"
  494.                MSG7 = "XXXX"
  495.                MSG8 = "XXXX"
  496.                MSG9 = "XXXX"
  497.                MSG0 = "XXXX"
  498.                NUM_ITEMS = 2
  499.                X = 23
  500.                Y = 1
  501.                W = LEN(MSG1)
  502.                MSTRING = "NM"
  503.                DO CLEARIT WITH X-1,Y,X,78
  504.                @ X-1,1 SAY BAR
  505.                DO H_LIGHT WITH NUM_ITEMS,X,Y,W,MSG1,MSG2,MSG3,MSG4,MSG5,MSG6,MSG7,MSG8,MSG9,MSG0,MSTRING
  506.                CHOICE = STR(SELECTION,1)
  507.                if CHOICE = "0"
  508.                   return
  509.                endif
  510.                do clearit with 21,1,23,78
  511.                skip
  512.             enddo
  513.             
  514.             @ 23,5 say "Press any key to proceed"
  515.             set console off
  516.             wait
  517.             set console on
  518.          endif
  519.       endcase
  520.    enddo
  521. enddo
  522. **********************************************************************
  523. **********************************************************************
  524. *                                                                    *
  525. *                      S. Robert Davidoff                            *
  526. *                                                                    *
  527. *                                                                    *
  528. **********************************************************************
  529. *                          AUD_ENT.PRG                               *
  530. **********************************************************************
  531.  
  532.  
  533. procedure aud_ent
  534. clear
  535. do banner with "ENTER AUDIO INFORMATION"
  536. do while .T.
  537.    mtitle = space(35)
  538.    mlastname = space(25)
  539.    mfirstname = space(25)
  540.    mmedium = space(1)          && Tape,Record,Compact disk
  541.    mtype = space(1)            && Instramental, Vocal, mixed
  542.    mcat = space(1)             && Jazz, Classical, Opera, Big band, Mellow or mood
  543.    do while .T.
  544.       answer = space(1)
  545.       @ 7,10 say "Enter Title: "
  546.       @ 7,33 get mtitle Picture "@!"
  547.       @ 9,10 say "Enter Last Name: "
  548.       @ 9,33 get mlastname Picture "@!"
  549.       @ 11,10 say "Enter First Name: "
  550.       @ 11,33 get mfirstname Picture "@!"
  551.       @ 13,10 say "T)ape   R)ecord  C)ompact disk "
  552.       @ 13,48 get mmedium picture "!" valid (mmedium $ "TRC")
  553.       @ 15,10 say "I)nstramental   V)ocal   M)ixed "
  554.       @ 15,48 get mtype picture "!" valid (mtype $ "IVM")
  555.       @ 17,10 say "J)azz   C)lassic   M)ellow "
  556.       @ 17,48 get mcat picture "!" valid (mcat $ "JCM")
  557.       do f1 with "HELP"
  558.       @ 0,0 to 24,79 double
  559.       read
  560.       MSG1 = "1. FILE "
  561.       MSG2 = "2. EDIT "
  562.       MSG3 = "0. ABORT"
  563.       MSG4 = "XXXX"
  564.       MSG5 = "XXXX"
  565.       MSG6 = "XXXX"
  566.       MSG7 = "XXXX"
  567.       MSG8 = "XXXX"
  568.       MSG9 = "XXXX"
  569.       MSG0 = "XXXX"
  570.       NUM_ITEMS = 3
  571.       X = 23
  572.       Y = 1
  573.       W = LEN(MSG1)
  574.       MSTRING = "FEA"
  575.       DO CLEARIT WITH X-1,Y,X,78
  576.       @ X-1,1 SAY BAR
  577.       DO H_LIGHT WITH NUM_ITEMS,X,Y,W,MSG1,MSG2,MSG3,MSG4,MSG5,MSG6,MSG7,MSG8,MSG9,MSG0,MSTRING
  578.       CHOICE = STR(SELECTION,1)
  579.       do case
  580.         case choice = "0"
  581.       return
  582.       case choice = "1"
  583.       exit
  584.       case choice = "2"
  585.       do clearit with 21,1,23,78
  586.       loop
  587.       endcase
  588.    enddo
  589.    append blank
  590.    replace title with mtitle
  591.    replace lastname with mlastname
  592.    replace firstname with mfirstname
  593.    replace medium with mmedium
  594.    replace type with mtype
  595.    replace cat with mcat
  596.    do clearit with 21,1,23,78
  597.    MSG1 = "1. ADD ANOTHER RECORD"
  598.    MSG2 = "0. MAIN MENU         "
  599.    MSG3 = "XXXX"
  600.    MSG4 = "XXXX"
  601.    MSG5 = "XXXX"
  602.    MSG6 = "XXXX"
  603.    MSG7 = "XXXX"
  604.    MSG8 = "XXXX"
  605.    MSG9 = "XXXX"
  606.    MSG0 = "XXXX"
  607.    NUM_ITEMS = 2
  608.    X = 23
  609.    Y = 1
  610.    W = LEN(MSG1)
  611.    MSTRING = "NM"
  612.    DO CLEARIT WITH X-1,Y,X,78
  613.    @ X-1,1 SAY BAR
  614.    DO H_LIGHT WITH NUM_ITEMS,X,Y,W,MSG1,MSG2,MSG3,MSG4,MSG5,MSG6,MSG7,MSG8,MSG9,MSG0,MSTRING
  615.    CHOICE = STR(SELECTION,1)
  616.    if choice = "0"
  617.       return
  618.    endif
  619.    do clearit with 21,1,23,78
  620. enddo
  621. **********************************************************************
  622. **********************************************************************
  623. **********************************************************************
  624. *aud_set.prg
  625. **********************************************************************
  626.  
  627.  
  628. procedure aud_set
  629. clear
  630. SET color to I
  631. do center with 12, "NOT READY WITH THIS YET"
  632. SET color to
  633. @ 0,0 TO 24,79 DOUBLE
  634. @ 6,20 TO 18,60 DOUBLE
  635. INKEY(0)
  636. RETURN
  637. **********************************************************************
  638. **********************************************************************
  639. *                                                                    *
  640. *S. Robert Davidoff*
  641. *                                                                    *
  642. *                                                                    *
  643. **********************************************************************
  644. *AUD_SRCH.PRG
  645. **********************************************************************
  646.  
  647.  
  648. procedure aud_srch
  649. do while .T.
  650.    select 1
  651.    use audio index a_title, a_artist
  652.    clear
  653.    do banner with "SEARCH AUDIO INFORMATION"
  654.    @ 0,0 to 24,79 double
  655.    do while .T.
  656.       mtitle = space(35)
  657.       mlastname = space(25)
  658.       mfirstname = space(25)
  659.       mmedium = space(1)          && Tape,Record,Compact disk
  660.       mtype = space(1)            && Instramental, Vocal, mixed
  661.       mcat = space(1)             && Jazz, Classical, Opera, Big band, Mellow or mood
  662.       heading1 = "1. LIST TO SCREEN"
  663.       heading2 = "2. LIST TO PRINT "
  664.       heading3 = "3. FIND TITLE    "
  665.       heading4 = "4. FIND ARTIST   "
  666.       heading5 = "0.MAIN MENU      "
  667.       heading6 = "XXXX"
  668.       heading7 = "XXXX"
  669.       heading8 = "XXXX"
  670.       heading9 = "XXXX"
  671.       heading0 = "XXXX"
  672.       num_items = 5
  673.       X = 7
  674.       Y =27
  675.       W = LEN(HEADING1)
  676.       @ 22,1 say bar
  677.       @ 23,2 say "Use UP and DOWN arrows to highlight choice...Press ENTER to select"
  678.       do lightbar with num_items,X,Y,W,heading1,heading2,heading3,heading4,heading5,heading6,heading7,heading8,heading9,heading0
  679.       choice = str(selection,1)
  680.       DO case
  681.       case choice = "0"
  682.          return
  683.       case choice = "1"
  684.          HELP_CODE = "00"
  685.          MSG1 = "1. ALL    "
  686.          MSG2 = "2. CD'S   "
  687.          MSG3 = "3. TAPES  "
  688.          MSG4 = "4. RECORDS"
  689.          MSG5 = "0. MENU   "
  690.          MSG6 = "XXXX"
  691.          MSG7 = "XXXX"
  692.          MSG8 = "XXXX"
  693.          MSG9 = "XXXX"
  694.          MSG0 = "XXXX"
  695.          NUM_ITEMS = 5
  696.          X = 23
  697.          Y = 1
  698.          W = LEN(MSG1)
  699.          MSTRING = "ACTRM"
  700.          DO CLEARIT WITH X-1,Y,X,78
  701.          @ X-1,1 SAY BAR
  702.          DO H_LIGHT WITH NUM_ITEMS,X,Y,W,MSG1,MSG2,MSG3,MSG4,MSG5,MSG6,MSG7,MSG8,MSG9,MSG0,MSTRING
  703.          CHOICE = STR(SELECTION,1)
  704.          DO CASE
  705.          case choice = "1"
  706.             set filter to
  707.          case choice = "2"
  708.             set filter to medium = "C"
  709.          case choice = "3"
  710.             set filter to medium = "T"
  711.          case choice = "4"
  712.             set filter to medium = "R"
  713.          case choice = "0"
  714.             return
  715.          endcase
  716.          clear
  717.          set order to 2
  718.          goto top
  719.          row = 1
  720.          do while .not. eof()
  721.             do case
  722.             case medium = "T"
  723.                mmedium = "TAPE"
  724.             CASE MEDIUM = "R"
  725.                MMEDIUM = "REC"
  726.             CASE MEDIUM = "C"
  727.                MMEDIUM = "CD"
  728.             endcase
  729.             do case
  730.             case type = "I"
  731.                mtype = "INS"
  732.             CASE TYPE = "V"
  733.                MTYPE = "VOC"
  734.             CASE TYPE = "M"
  735.                MTYPE = "MIX"
  736.             endcase
  737.             do case
  738.             case cat = "J"
  739.                mcat = "JAZZ"
  740.             case cat = "C"
  741.                mcat = "CLAS"
  742.             case cat = "M"
  743.                mcat = "MOOD"
  744.             endcase
  745.             @ row,0 say trim(title)
  746.             if empty(firstname)
  747.                @ row,33 say trim(lastname)
  748.             else
  749.                @ row,33 say trim(lastname) + "," + trim(firstname)
  750.             endif
  751.             @ row,58 say mmedium
  752.             @ row,66 say  mtype
  753.             @ row,73 say mcat
  754.             row = row()+1
  755.             if row > 20
  756.                @ 23,5 say "Press any key to proceed"
  757.                set console off
  758.                wait to choice
  759.                set console on
  760.                if choice = "0" .or. upper(choice) = "M"
  761.                   return
  762.                endif
  763.                skip
  764.                if eof()
  765.                   return
  766.                endif
  767.                clear
  768.                row = 1
  769.             else
  770.                skip
  771.             endif
  772.          enddo
  773.          @ 23,5 say "Press any key to proceed"
  774.          set console off
  775.          wait
  776.          set console on
  777.          return
  778.          
  779.       case choice = "2"
  780.          MSG1 = "1. ALL    "
  781.          MSG2 = "2. CD'S   "
  782.          MSG3 = "3. TAPES  "
  783.          MSG4 = "4. RECORDS"
  784.          MSG5 = "0. MENU   "
  785.          MSG6 = "XXXX"
  786.          MSG7 = "XXXX"
  787.          MSG8 = "XXXX"
  788.          MSG9 = "XXXX"
  789.          MSG0 = "XXXX"
  790.          NUM_ITEMS = 5
  791.          X = 23
  792.          Y = 1
  793.          W = LEN(MSG1)
  794.          MSTRING = "ACTRM"
  795.          DO CLEARIT WITH X-1,Y,X,78
  796.          @ X-1,1 SAY BAR
  797.          DO H_LIGHT WITH NUM_ITEMS,X,Y,W,MSG1,MSG2,MSG3,MSG4,MSG5,MSG6,MSG7,MSG8,MSG9,MSG0,MSTRING
  798.          CHOICE = STR(SELECTION,1)
  799.          DO CASE
  800.          case choice = "1"
  801.             set filter to
  802.          case choice = "2"
  803.             set filter to medium = "C"
  804.          case choice = "3"
  805.             set filter to medium = "J"
  806.          case choice = "4"
  807.             set filter to medium = "R"
  808.          case choice = "0"
  809.             return
  810.          endcase
  811.          clear
  812.          do print_set
  813.          if upper(choice) = "A"
  814.             return
  815.          endif
  816.          set device to print
  817.          set order to 2
  818.          goto top
  819.          row = 5
  820.          do while .not. eof()
  821.             do case
  822.             case medium = "T"
  823.                mmedium = "TAPE"
  824.             CASE MEDIUM = "R"
  825.                MMEDIUM = "REC"
  826.             CASE MEDIUM = "C"
  827.                MMEDIUM = "CD"
  828.             endcase
  829.             do case
  830.             case type = "I"
  831.                mtype = "INST"
  832.             CASE TYPE = "V"
  833.                MTYPE = "VOC"
  834.             CASE TYPE = "M"
  835.                MTYPE = "MIX"
  836.             endcase
  837.             do case
  838.             case cat = "J"
  839.                mcat = "JAZZ"
  840.             case cat = "C"
  841.                mcat = "CLAS"
  842.             case cat = "M"
  843.                mcat = "MOOD"
  844.             endcase
  845.             @ row,2 say trim(title)
  846.             if empty(firstname)
  847.                @ row,35 say trim(lastname)
  848.             else
  849.                @ row,35 say trim(lastname) + "," + trim(firstname)
  850.             endif
  851.             @ row,58 say mmedium
  852.             @ row,66 say  mtype
  853.             @ row,73 say mcat
  854.             row = prow()+1
  855.             if row > 50
  856.                skip
  857.                if eof()
  858.                   return
  859.                endif
  860.                eject
  861.                row = 5
  862.             else
  863.                skip
  864.             endif
  865.          enddo
  866.          eject
  867.          set device to screen
  868.          return
  869.          **********************************************************************
  870.          *FIND TITLES
  871.          **********************************************************************
  872.          
  873.       case choice = "3"
  874.          HELP_CODE = "AT"
  875.          set order to 1
  876.          goto top
  877.          mtitle = space(35)
  878.          do clearit with 1,1,23,78
  879.          @ 8,20 say "Enter Title: " get mtitle Picture "@!"
  880.          DO F1 WITH "LIST TITLES"
  881.          read
  882.          row = 1
  883.          mtitle = alltrim(mtitle)
  884.          seek mtitle
  885.          if eof()
  886.             goto top
  887.             do clearit with 1,1,23,78
  888.             do while ! eof()
  889.                if AT(mtitle,title) > 0
  890.                   ************
  891.                   
  892.                   do case
  893.                   case medium = "T"
  894.                      mmedium = "TAPE"
  895.                   CASE MEDIUM = "R"
  896.                      MMEDIUM = "REC"
  897.                   CASE MEDIUM = "C"
  898.                      MMEDIUM = "CD"
  899.                   endcase
  900.                   do case
  901.                   case type = "I"
  902.                      mtype = "INS"
  903.                   CASE TYPE = "V"
  904.                      MTYPE = "VOC"
  905.                   CASE TYPE = "M"
  906.                      MTYPE = "MIX"
  907.                   endcase
  908.                   do case
  909.                   case cat = "J"
  910.                      mcat = "JAZZ"
  911.                   case cat = "C"
  912.                      mcat = "CLAS"
  913.                   case cat = "M"
  914.                      mcat = "MOOD"
  915.                   endcase
  916.                   @ row,1 say trim(title)
  917.                   if empty(firstname)
  918.                      @ row,33 say trim(lastname)
  919.                   else
  920.                      @ row,33 say trim(lastname) + "," + trim(firstname)
  921.                   endif
  922.                   @ row,57 say mmedium
  923.                   @ row,65 say  mtype
  924.                   @ row,72 say mcat
  925.                   ************
  926.                   *@ row,5 say title
  927.                   *@ row,40 say trim(lastname) + "," + firstname
  928.                   row = row+1
  929.                   if row > 20
  930.                      @ 23,5 say "Press any key to proceed"
  931.                      set console off
  932.                      wait to choice
  933.                      set console on
  934.                      if choice = "0"
  935.                         return
  936.                      endif
  937.                      skip
  938.                      if eof()
  939.                         loop
  940.                      else
  941.                         row = 1
  942.                         do clearit with 1,1,23,78
  943.                         loop
  944.                      endif
  945.                   endif
  946.                endif
  947.                skip
  948.             enddo
  949.             @ 23,5 say "Press any key to proceed"
  950.             set console off
  951.             wait
  952.             set console on
  953.          else
  954.             do clearit with 1,1,23,78
  955.             do while ! eof() .and. (mtitle = substr(title,1,(len(mtitle))))
  956.                ************
  957.                
  958.                do case
  959.                case medium = "T"
  960.                   mmedium = "TAPE"
  961.                CASE MEDIUM = "R"
  962.                   MMEDIUM = "REC"
  963.                CASE MEDIUM = "C"
  964.                   MMEDIUM = "CD"
  965.                endcase
  966.                do case
  967.                case type = "I"
  968.                   mtype = "INS"
  969.                CASE TYPE = "V"
  970.                   MTYPE = "VOC"
  971.                CASE TYPE = "M"
  972.                   MTYPE = "MIX"
  973.                endcase
  974.                do case
  975.                case cat = "J"
  976.                   mcat = "JAZZ"
  977.                case cat = "C"
  978.                   mcat = "CLAS"
  979.                case cat = "M"
  980.                   mcat = "MOOD"
  981.                endcase
  982.                @ row,1 say trim(title)
  983.                if empty(firstname)
  984.                   @ row,33 say trim(lastname)
  985.                else
  986.                   @ row,33 say trim(lastname) + "," + trim(firstname)
  987.                endif
  988.                @ row,57 say mmedium
  989.                @ row,65 say  mtype
  990.                @ row,72 say mcat
  991.                ************
  992.                
  993.                
  994.                *@ row,5 say title
  995.                *@ row,40 say trim(lastname) + "," + firstname
  996.                row = row+1
  997.                if row > 20
  998.                   @ 23,5 say "Press any key to proceed"
  999.                   set console off
  1000.                   wait to choice
  1001.                   set console on
  1002.                   if choice = "0"
  1003.                      return
  1004.                   endif
  1005.                   skip
  1006.                   if eof()
  1007.                      loop
  1008.                   else
  1009.                      row = 1
  1010.                      do clearit with 1,1,23,78
  1011.                      loop
  1012.                   endif
  1013.                endif
  1014.                skip
  1015.             enddo
  1016.             @ 23,5 say "Press any key to proceed"
  1017.             set console off
  1018.             wait
  1019.             set console on
  1020.          endif
  1021.          **********************************************************************
  1022.          *                          FIND ARTISTS
  1023.          **********************************************************************
  1024.          
  1025.       case choice = "4"
  1026.          
  1027.          set order to 2
  1028.          goto top
  1029.          mLastName = space(35)
  1030.          do clearit with 1,1,23,78
  1031.          @ 8,20 say "Enter Last Name: " get mLastName Picture "@!"
  1032.          DO F1 WITH "HELP"
  1033.          read
  1034.          row = 1
  1035.          mLastName = alltrim(mLastName)
  1036.          seek mLastName
  1037.          if eof()
  1038.             goto top
  1039.             do clearit with 1,1,23,78
  1040.             do while ! eof()
  1041.                if AT(mLastName,LastName) > 0
  1042.                   *****************
  1043.                   do case
  1044.                   case medium = "T"
  1045.                      mmedium = "TAPE"
  1046.                   CASE MEDIUM = "R"
  1047.                      MMEDIUM = "REC"
  1048.                   CASE MEDIUM = "C"
  1049.                      MMEDIUM = "CD"
  1050.                   endcase
  1051.                   do case
  1052.                   case type = "I"
  1053.                      mtype = "INS"
  1054.                   CASE TYPE = "V"
  1055.                      MTYPE = "VOC"
  1056.                   CASE TYPE = "M"
  1057.                      MTYPE = "MIX"
  1058.                   endcase
  1059.                   do case
  1060.                   case cat = "J"
  1061.                      mcat = "JAZZ"
  1062.                   case cat = "C"
  1063.                      mcat = "CLAS"
  1064.                   case cat = "M"
  1065.                      mcat = "MOOD"
  1066.                   endcase
  1067.                   @ row,1 say trim(title)
  1068.                   if empty(firstname)
  1069.                      @ row,33 say trim(lastname)
  1070.                   else
  1071.                      @ row,33 say trim(lastname) + "," + trim(firstname)
  1072.                   endif
  1073.                   @ row,57 say mmedium
  1074.                   @ row,65 say  mtype
  1075.                   @ row,72 say mcat
  1076.                   row = row+1
  1077.                   if row > 20
  1078.                      @ 23,5 say "Press any key to proceed"
  1079.                      set console off
  1080.                      wait to choice
  1081.                      set console on
  1082.                      if choice = "0"
  1083.                         return
  1084.                      endif
  1085.                      skip
  1086.                      if eof()
  1087.                         loop
  1088.                      else
  1089.                         row = 1
  1090.                         do clearit with 1,1,23,78
  1091.                         loop
  1092.                      endif
  1093.                   endif
  1094.                endif
  1095.                skip
  1096.             enddo
  1097.             @ 23,5 say "Press any key to proceed"
  1098.             set console off
  1099.             wait
  1100.             set console on
  1101.          else
  1102.             do clearit with 1,1,23,78
  1103.             do while ! eof() .and. (mLastName = substr(LastName,1,(len(mLastName))))
  1104.                ***********
  1105.                do case
  1106.                case medium = "T"
  1107.                   mmedium = "TAPE"
  1108.                CASE MEDIUM = "R"
  1109.                   MMEDIUM = "REC"
  1110.                CASE MEDIUM = "C"
  1111.                   MMEDIUM = "CD"
  1112.                endcase
  1113.                do case
  1114.                case type = "I"
  1115.                   mtype = "INS"
  1116.                CASE TYPE = "V"
  1117.                   MTYPE = "VOC"
  1118.                CASE TYPE = "M"
  1119.                   MTYPE = "MIX"
  1120.                endcase
  1121.                do case
  1122.                case cat = "J"
  1123.                   mcat = "JAZZ"
  1124.                case cat = "C"
  1125.                   mcat = "CLAS"
  1126.                case cat = "M"
  1127.                   mcat = "MOOD"
  1128.                endcase
  1129.                @ row,1 say trim(title)
  1130.                if empty(firstname)
  1131.                   @ row,33 say trim(lastname)
  1132.                else
  1133.                   @ row,33 say trim(lastname) + "," + trim(firstname)
  1134.                endif
  1135.                @ row,57 say mmedium
  1136.                @ row,65 say  mtype
  1137.                @ row,72 say mcat
  1138.                row = row+1
  1139.                if row > 20
  1140.                   @ 23,5 say "Press any key to proceed"
  1141.                   set console off
  1142.                   wait to choice
  1143.                   set console on
  1144.                   if choice = "0"
  1145.                      return
  1146.                   endif
  1147.                   skip
  1148.                   if eof()
  1149.                      loop
  1150.                   else
  1151.                      row = 1
  1152.                      do clearit with 1,1,23,78
  1153.                      loop
  1154.                   endif
  1155.                endif
  1156.                skip
  1157.             enddo
  1158.             @ 23,5 say "Press any key to proceed"
  1159.             set console off
  1160.             wait
  1161.             set console on
  1162.          endif
  1163.       endcase
  1164.       do clearit with 1,1,23,78
  1165.    enddo
  1166. enddo
  1167. **********************************************************************
  1168. ****************************END AUDIO.PRG*****************************
  1169. **********************************************************************
  1170.