home *** CD-ROM | disk | FTP | other *** search
- * Program.: SAMPLE.PRG
- * Author..: Your Name
- * Date....: 11/05/85
- * Notice..: Copyright 1985, Your Company, All Rights Reserved
- * Version.: dBASE III, version 1.1
- * Notes...: MAIN program for NAMES.DBF
- *
- * ---SET environment.
- SET TALK OFF
- SET BELL OFF
- SET MENU OFF
- SET SAFETY OFF
- SET ESCAPE OFF
- SET SCOREBOARD OFF
- * ---Open PROCEDURE file.
- SET PROCEDURE TO SAM_PROC
- * ---SET COLOR TO values.
- StatusAtr = "B/,/W"
- WindowAtr = "R+/,/W"
- PromptAtr = "GR/,/W"
- * ---Initialize global variables.
- PromptRow = 21
- STORE 0 TO key,LastRec
- STORE 1 TO oldrecnum,pageno
- STORE " " TO choice,expr
- PromptBar = "────────────────────────────────────────" +;
- "────────────────────────────────────────"
- PgDn = "N"
- Returnkey = " "
- DelRecord = "D"
- CtrlEnd = " "
- * ---Open files.
- DO OpenFile
- * ---Execute main loop.
- DO WHILE .T.
- * ---Display main menu and get choice.
- DO SAM_MENU WITH choice
- DO CASE
- CASE choice $ "Q"+Returnkey
- EXIT
- CASE .NOT. choice $ "AH" .AND. LastRec = 0
- @ 17, 0 SAY "EMPTY DATABASE FILE: Only Append and Help are available."
- WAIT
- CASE choice = "A"
- * ---DO APPEND.
- @ 17, 0 CLEAR
- @ 17, 0 SAY "Preparing to add records..."
- DO SAM_APPE WITH PromptRow
- CASE choice = "B"
- * ---BROWSE the database file.
- SET SCOREBOARD ON
- SET MENU ON
- BROWSE
- SET MENU OFF
- SET SCOREBOARD OFF
- CASE choice = "E"
- * ---DO EDIT/VIEW.
- DO SAM_EDIT WITH PromptRow
- CASE choice = "H"
- * ---DO HELP.
- DO SAM_HELP
- CASE choice = "L"
- * ---DO LABELS.
- DO SAM_LABE
- CASE choice = "P"
- * ---DO PACK.
- @ 17, 0 SAY "PACK the entire file? (y/n)"
- DO GetKey WITH choice,"YN"+Returnkey
- @ 17,0 CLEAR
- IF choice = "Y"
- @ 17, 0 SAY "PACKing the file..."
- DO SAM_PACK WITH 17,"NAMES.$$$","NAMES.DBF","NAMES",;
- "Lastname + Firstname"
- DO OpenFile
- IF LastRec < oldrecnum
- oldrecnum = LastRec
- ENDIF
- ENDIF
- CASE choice = "R"
- * ---DO REPORT.
- DO SAM_REPO
- ENDCASE
- ENDDO
- * ---Closing operations.
- CLEAR
- CLOSE DATABASE
- CLOSE PROCEDURE
- SET SCOREBOARD ON
- SET ESCAPE ON
- SET SAFETY ON
- SET MENU ON
- SET BELL ON
- SET TALK ON
- RETURN
- * EOF: SAMPLE.PRG