home *** CD-ROM | disk | FTP | other *** search
- * *********************************************************
- * *
- * * 01/26/94 INVOICES.SPR 16:33:35
- * *
- * *********************************************************
- * *
- * * Author's Name
- * *
- * * Copyright (c) 1994 Company Name
- * * Address
- * * City, Zip
- * *
- * * Description:
- * * This program was automatically generated by GENSCRN.
- * *
- * *********************************************************
-
-
- #REGION 0
- REGIONAL m.currarea, m.talkstat, m.compstat
-
- IF SET("TALK") = "ON"
- SET TALK OFF
- m.talkstat = "ON"
- ELSE
- m.talkstat = "OFF"
- ENDIF
- m.compstat = SET("COMPATIBLE")
- SET COMPATIBLE FOXPLUS
-
- m.rborder = SET("READBORDER")
- SET READBORDER ON
-
- m.currarea = SELECT()
-
-
- * *********************************************************
- * *
- * * S9614641/Windows Databases, Indexes, Relations
- * *
- * *********************************************************
- *
-
- IF USED("invoices")
- SELECT invoices
- SET ORDER TO TAG "_qml0km38e"
- ELSE
- SELECT 0
- USE (LOCFILE("invoices.dbf","DBF","Where is invoices?"));
- AGAIN ALIAS invoices ;
- ORDER TAG "_qml0km38e"
- ENDIF
-
-
- * *********************************************************
- * *
- * * Windows Window definitions
- * *
- * *********************************************************
- *
-
- IF NOT WEXIST("_qn00zhr1p")
- DEFINE WINDOW _qn00zhr1p ;
- AT 0.000, 0.000 ;
- SIZE 13.751,62.500 ;
- TITLE "Invoices" ;
- FONT "ms sans serif", 10 ;
- STYLE "B" ;
- FLOAT ;
- CLOSE ;
- MINIMIZE ;
- COLOR RGB(,,,192,192,192)
- MOVE WINDOW _qn00zhr1p CENTER
- ENDIF
-
-
- * *********************************************************
- * *
- * * INVOICES/Windows Setup Code - SECTION 2
- * *
- * *********************************************************
- *
-
- #REGION 1
-
-
- #DEFINE C_DBFEMPTY 'Database is empty, add a record?'
- #DEFINE C_EDITS 'Please finish your edits.'
- #DEFINE C_TOPFILE 'Top of file.'
- #DEFINE C_ENDFILE 'End of file.'
- #DEFINE C_BRTITLE 'Locate Record'
- #DEFINE C_NOLOCK 'Sorry, could not lock record -- try again later.'
- #DEFINE C_ECANCEL 'Edits Canceled.'
- #DEFINE C_DELREC 'Delete selected record?'
- #DEFINE C_NOFEAT 'Feature not available yet.'
- #DEFINE C_NOWIZ 'Wizard application is not available.'
- #DEFINE C_MAKEREPO 'Creating report with ReportWizard.'
- #DEFINE C_NOREPO 'Could not create report.'
-
- MOVE WINDOW '_qn00zhr1p' CENTER
- PRIVATE isediting,isadding,wzolddelete,wzolderror,wzalias,tempcurs
- m.isediting=.F.
- m.isadding=.F.
- m.wzolddelete=SET('DELETE')
- SET DELETED ON
- m.wzalias=SELECT()
- m.tempcurs=SYS(2015) &&used if General field
-
- IF RECCOUNT()=0
- IF fox_alert(C_DBFEMPTY)
- APPEND BLANK
- ENDIF
- ENDIF
- GOTO TOP
- SCATTER MEMVAR MEMO
- m.wzolderror=ON('error')
- ON ERROR DO wizerrorhandler
-
-
- * *********************************************************
- * *
- * * INVOICES/Windows Screen Layout
- * *
- * *********************************************************
- *
-
- #REGION 1
- IF WVISIBLE("_qn00zhr1p")
- ACTIVATE WINDOW _qn00zhr1p SAME
- ELSE
- ACTIVATE WINDOW _qn00zhr1p NOSHOW
- ENDIF
- @ 0.313,3.000 SAY "Invoices" ;
- FONT "MS Sans Serif", 14 ;
- STYLE "BT"
- @ 2.125,0.000 TO 2.125,62.500 ;
- PEN 4, 8 ;
- STYLE "1"
- @ 0.813,48.000 SAY "Date:" ;
- FONT "MS Sans Serif", 8 ;
- STYLE "BT"
- @ 0.813,52.750 SAY date() ;
- SIZE 1.000,11.200 ;
- FONT "MS Sans Serif", 8
- @ 3.063,3.250 SAY "Ino:" ;
- SIZE 1.000,9.667 ;
- FONT "MS Sans Serif", 8 ;
- STYLE "BT" ;
- PICTURE "@J" ;
- COLOR RGB(,,,255,255,255)
- @ 3.250,12.875 TO 4.125,17.250 ;
- PATTERN 1 ;
- PEN 1, 8 ;
- COLOR RGB(128,128,128,128,128,128)
- @ 3.063,12.625 GET m.ino ;
- SIZE 1.000,6.000 ;
- DEFAULT " " ;
- FONT "MS Sans Serif", 8 ;
- PICTURE "@K 9,999" ;
- WHEN isediting ;
- COLOR ,RGB(,,,255,255,255)
- @ 4.563,3.250 SAY "Cno:" ;
- SIZE 1.000,9.667 ;
- FONT "MS Sans Serif", 8 ;
- STYLE "BT" ;
- PICTURE "@J" ;
- COLOR RGB(,,,255,255,255)
- @ 4.750,12.875 TO 5.625,20.375 ;
- PATTERN 1 ;
- PEN 1, 8 ;
- COLOR RGB(128,128,128,128,128,128)
- @ 4.563,12.625 GET m.cno ;
- SIZE 1.000,11.000 ;
- DEFAULT " " ;
- FONT "MS Sans Serif", 8 ;
- PICTURE "@K XXXXX" ;
- WHEN isediting ;
- COLOR ,RGB(,,,255,255,255)
- @ 6.063,3.250 SAY "Idate:" ;
- SIZE 1.000,9.667 ;
- FONT "MS Sans Serif", 8 ;
- STYLE "BT" ;
- PICTURE "@J" ;
- COLOR RGB(,,,255,255,255)
- @ 6.250,12.875 TO 7.125,19.250 ;
- PATTERN 1 ;
- PEN 1, 8 ;
- COLOR RGB(128,128,128,128,128,128)
- @ 6.063,12.625 GET m.idate ;
- SIZE 1.000,9.200 ;
- DEFAULT " " ;
- FONT "MS Sans Serif", 8 ;
- PICTURE "@K" ;
- WHEN isediting ;
- COLOR ,RGB(,,,255,255,255)
- @ 7.563,3.250 SAY "Itotal:" ;
- SIZE 1.000,9.667 ;
- FONT "MS Sans Serif", 8 ;
- STYLE "BT" ;
- PICTURE "@J" ;
- COLOR RGB(,,,255,255,255)
- @ 7.750,12.875 TO 8.625,20.250 ;
- PATTERN 1 ;
- PEN 1, 8 ;
- COLOR RGB(128,128,128,128,128,128)
- @ 7.563,12.625 GET m.itotal ;
- SIZE 1.000,10.800 ;
- DEFAULT " " ;
- FONT "MS Sans Serif", 8 ;
- PICTURE "@K 99,999.99" ;
- WHEN isediting ;
- COLOR ,RGB(,,,255,255,255)
- @ 9.063,3.250 SAY "Salesman:" ;
- SIZE 1.000,9.667 ;
- FONT "MS Sans Serif", 8 ;
- STYLE "BT" ;
- PICTURE "@J" ;
- COLOR RGB(,,,255,255,255)
- @ 9.250,12.875 TO 10.125,17.625 ;
- PATTERN 1 ;
- PEN 1, 8 ;
- COLOR RGB(128,128,128,128,128,128)
- @ 9.063,12.625 GET m.salesman ;
- SIZE 1.000,6.600 ;
- DEFAULT " " ;
- FONT "MS Sans Serif", 8 ;
- PICTURE "@K XXX" ;
- WHEN isediting ;
- COLOR ,RGB(,,,255,255,255)
- @ 10.563,0.000 TO 10.563,62.500 ;
- PEN 4, 8 ;
- STYLE "1"
- @ 11.563,1.500 GET m.top_btn ;
- PICTURE "@*HN \<Top" ;
- SIZE 1.769,7.833,0.667 ;
- DEFAULT 1 ;
- FONT "MS Sans Serif", 8 ;
- STYLE "B" ;
- VALID btn_val('TOP') ;
- MESSAGE 'Go to first record.'
- @ 11.563,7.500 GET m.prev_btn ;
- PICTURE "@*HN \<Prev" ;
- SIZE 1.769,7.833,0.667 ;
- DEFAULT 1 ;
- FONT "MS Sans Serif", 8 ;
- STYLE "B" ;
- VALID btn_val('PREV') ;
- MESSAGE 'Go to previous record.'
- @ 11.563,13.500 GET m.next_btn ;
- PICTURE "@*HN \<Next" ;
- SIZE 1.769,7.833,0.667 ;
- DEFAULT 1 ;
- FONT "MS Sans Serif", 8 ;
- STYLE "B" ;
- VALID btn_val('NEXT') ;
- MESSAGE 'Go to next record.'
- @ 11.563,19.500 GET m.end_btn ;
- PICTURE "@*HN \<End" ;
- SIZE 1.769,7.833,0.667 ;
- DEFAULT 1 ;
- FONT "MS Sans Serif", 8 ;
- STYLE "B" ;
- VALID btn_val('END') ;
- MESSAGE 'Go to last record.'
- @ 11.563,25.500 GET m.loc_btn ;
- PICTURE "@*HN \<Locate" ;
- SIZE 1.769,7.833,0.667 ;
- DEFAULT 1 ;
- FONT "MS Sans Serif", 8 ;
- STYLE "B" ;
- VALID btn_val('LOCATE') ;
- MESSAGE 'Locate a record.'
- @ 11.563,31.500 GET m.add_btn ;
- PICTURE "@*HN \<Add" ;
- SIZE 1.769,7.833,0.667 ;
- DEFAULT 1 ;
- FONT "MS Sans Serif", 8 ;
- STYLE "B" ;
- VALID btn_val('ADD') ;
- MESSAGE 'Add a new record.'
- @ 11.563,37.500 GET m.edit_btn ;
- PICTURE "@*HN Ed\<it" ;
- SIZE 1.769,7.833,0.667 ;
- DEFAULT 1 ;
- FONT "MS Sans Serif", 8 ;
- STYLE "B" ;
- VALID btn_val('EDIT') ;
- MESSAGE 'Edit current record.'
- @ 11.563,43.500 GET m.del_btn ;
- PICTURE "@*HN \<Delete" ;
- SIZE 1.769,7.833,0.667 ;
- DEFAULT 1 ;
- FONT "MS Sans Serif", 8 ;
- STYLE "B" ;
- VALID btn_val('DELETE') ;
- MESSAGE 'Delete current record.'
- @ 11.563,49.500 GET m.prnt_btn ;
- PICTURE "@*HN P\<rint" ;
- SIZE 1.769,7.833,0.667 ;
- DEFAULT 1 ;
- FONT "MS Sans Serif", 8 ;
- STYLE "B" ;
- VALID btn_val('PRINT') ;
- MESSAGE 'Print report.'
- @ 11.563,55.500 GET m.exit_btn ;
- PICTURE "@*HN \<Close" ;
- SIZE 1.769,7.667,0.667 ;
- DEFAULT 1 ;
- FONT "MS Sans Serif", 8 ;
- STYLE "B" ;
- VALID btn_val('EXIT') ;
- MESSAGE 'Close screen.'
-
- IF NOT WVISIBLE("_qn00zhr1p")
- ACTIVATE WINDOW _qn00zhr1p
- ENDIF
-
-
- * *********************************************************
- * *
- * * WindowsREAD contains clauses from SCREEN s9614641
- * *
- * *********************************************************
- *
-
- READ CYCLE ;
- ACTIVATE READACT() ;
- DEACTIVATE READDEAC() ;
- NOLOCK
-
- RELEASE WINDOW _qn00zhr1p
-
- * *********************************************************
- * *
- * * Windows Closing Databases
- * *
- * *********************************************************
- *
-
- IF USED("invoices")
- SELECT invoices
- USE
- ENDIF
-
- SELECT (m.currarea)
-
-
- #REGION 0
-
- SET READBORDER &rborder
-
- IF m.talkstat = "ON"
- SET TALK ON
- ENDIF
- IF m.compstat = "ON"
- SET COMPATIBLE ON
- ENDIF
-
-
- * *********************************************************
- * *
- * * INVOICES/Windows Cleanup Code
- * *
- * *********************************************************
- *
-
- #REGION 1
- SET DELETED &wzolddelete
- ON ERROR &wzolderror
-
- ****Procedures****
-
-
- * *********************************************************
- * *
- * * INVOICES/Windows Supporting Procedures and Functions
- * *
- * *********************************************************
- *
-
- #REGION 1
- PROCEDURE readdeac
- IF isediting
- ACTIVATE WINDOW (WLAST())
- WAIT WINDOW C_EDITS NOWAIT
- ENDIF
- IF !WVISIBLE(WOUTPUT())
- CLEAR READ
- RETURN .T.
- ENDIF
- RETURN .F.
-
- PROCEDURE readact
- IF !isediting
- SELECT (m.wzalias)
- SHOW GETS
- ENDIF
- RETURN
-
- PROCEDURE fox_alert
- PARAMETER wzalrtmess
- PRIVATE alrtbtn
- m.alrtbtn=2
- DEFINE WINDOW _qec1ij2t7 AT 0,0 SIZE 8,50 ;
- FONT "MS Sans Serif",10 STYLE 'B' ;
- FLOAT NOCLOSE NOMINIMIZE DOUBLE TITLE WTITLE()
- MOVE WINDOW _qec1ij2t7 CENTER
- ACTIVATE WINDOW _qec1ij2t7 NOSHOW
- @ 2,(50-txtwidth(wzalrtmess))/2 SAY wzalrtmess;
- FONT "MS Sans Serif", 10 STYLE "B"
- @ 6,18 GET m.alrtbtn ;
- PICTURE "@*HT \<OK;\?\!\<Cancel" ;
- SIZE 1.769,8.667,1.333 ;
- FONT "MS Sans Serif", 8 STYLE "B"
- ACTIVATE WINDOW _qec1ij2t7
- READ CYCLE MODAL
- RELEASE WINDOW _qec1ij2t7
- RETURN m.alrtbtn=1
-
-
- PROCEDURE BTN_VAL
- PARAMETER m.btnname
- DO CASE
- CASE m.btnname='TOP'
- GO TOP
- WAIT WINDOW C_TOPFILE NOWAIT
- CASE m.btnname='PREV'
- IF !BOF()
- SKIP -1
- ENDIF
- IF BOF()
- WAIT WINDOW C_TOPFILE NOWAIT
- GO TOP
- ENDIF
- CASE m.btnname='NEXT'
- IF !EOF()
- SKIP 1
- ENDIF
- IF EOF()
- WAIT WINDOW C_ENDFILE NOWAIT
- GO BOTTOM
- ENDIF
- CASE m.btnname='END'
- GO BOTTOM
- WAIT WINDOW C_ENDFILE NOWAIT
- CASE m.btnname='LOCATE'
- DEFINE WINDOW wzlocate FROM 1,1 TO 15,35;
- SYSTEM GROW CLOSE ZOOM FLOAT
- MOVE WINDOW wzlocate CENTER
- BROWSE WINDOW wzlocate NOEDIT NODELETE NOMENU ;
- TITLE C_BRTITLE
- RELEASE WINDOW wzlocate
- CASE m.btnname='ADD' AND !isediting &&add record
- isediting=.T.
- isadding=.T.
- =edithand('ADD')
- _curobj=1
- DO refresh
- SHOW GETS
- RETURN
- CASE m.btnname='EDIT' AND !isediting &&edit record
- IF EOF() OR BOF()
- WAIT WINDOW C_ENDFILE NOWAIT
- RETURN
- ENDIF
- IF RLOCK()
- isediting=.T.
- _curobj=1
- DO refresh
- RETURN
- ELSE
- WAIT WINDOW C_NOLOCK
- ENDIF
- CASE m.btnname='EDIT' AND isediting &&save record
- IF isadding
- =edithand('SAVE')
- ELSE
- GATHER MEMVAR MEMO
- UNLOCK
- ENDIF
- isediting=.F.
- isadding=.F.
- DO refresh
- CASE m.btnname='DELETE' AND isediting &&cancel record
- IF isadding
- =edithand('CANCEL')
- ENDIF
- isediting=.F.
- isadding=.F.
- WAIT WINDOW C_ECANCEL NOWAIT
- DO refresh
- CASE m.btnname='DELETE'
- IF EOF() OR BOF()
- WAIT WINDOW C_ENDFILE NOWAIT
- RETURN
- ENDIF
- IF fox_alert(C_DELREC)
- DELETE
- IF !EOF()
- SKIP 1
- ENDIF
- IF EOF()
- WAIT WINDOW C_ENDFILE NOWAIT
- GO BOTTOM
- ENDIF
- ENDIF
- CASE m.btnname='PRINT'
- PRIVATE sOldError,wizfname,saverec
- PRIVATE prnt_btn,p_recs,p_output,pr_out,pr_record
- STORE 1 TO p_recs,p_output
- STORE 0 TO prnt_btn
- STORE RECNO() TO saverec
- m.sOldError=ON('error')
- DO pdialog
- IF m.prnt_btn = 2
- RETURN
- ENDIF
- IF !FILE(ALIAS()+'.FRX')
- m.wizfname=SYS(2004)+'WIZARDS\'+'WIZARD.APP'
- IF !FILE(m.wizfname)
- ON ERROR *
- m.wizfname=LOCFILE('WIZARD.APP','APP','Locate WIZARD.APP:')
- ON ERROR &sOldError
- IF !'WIZARD.APP'$UPPER(m.wizfname)
- WAIT WINDOW C_NOWIZ
- RETURN
- ENDIF
- ENDIF
- WAIT WINDOW C_MAKEREPO NOWAIT
- DO (m.wizfname) WITH '','WZ_QREPO','NOSCRN;VERTICAL'
- WAIT CLEAR
- IF !FILE(ALIAS()+'.FRX') &&wizard could not create report
- WAIT WINDOW C_NOREPO
- RETURN
- ENDIF
- ENDIF
-
- m.pr_out=IIF(m.p_output=1,'TO PRINT NOCONSOLE','PREVIEW')
- m.pr_record=IIF(m.p_recs=1,'NEXT 1','ALL')
- ON ERROR *
- REPORT FORM (ALIAS()) &pr_out &pr_record
- ON ERROR &sOldError
- GO m.saverec
-
- CASE m.btnname='EXIT'
- m.bailout=.T. &&this is needed if used with FoxApp
- CLEAR READ
- RETURN
- ENDCASE
- SCATTER MEMVAR MEMO
- SHOW GETS
- RETURN
-
- PROCEDURE REFRESH
- IF isediting
- SHOW GET top_btn DISABLE
- SHOW GET prev_btn DISABLE
- SHOW GET next_btn DISABLE
- SHOW GET end_btn DISABLE
- SHOW GET loc_btn DISABLE
- SHOW GET add_btn DISABLE
- SHOW GET del_btn DISABLE
- SHOW GET exit_btn DISABLE
- SHOW GET prnt_btn DISABLE
-
- SHOW GET edit_btn,1 PROMPT "\<Save"
- SHOW GET del_btn,1 PROMPT "\<Cancel"
- ELSE
- SHOW GET edit_btn,1 PROMPT "\<Edit"
- SHOW GET del_btn,1 PROMPT "\<Delete"
- SHOW GETS ENABLE
- ENDIF
- RETURN
-
-
- PROCEDURE pdialog
- DEFINE WINDOW _qjn12zbvh ;
- AT 0.000, 0.000 ;
- SIZE 13.231,54.800 ;
- TITLE "Microsoft FoxPro" ;
- FONT "MS Sans Serif", 8 ;
- FLOAT NOCLOSE MINIMIZE SYSTEM
- MOVE WINDOW _qjn12zbvh CENTER
- ACTIVATE WINDOW _qjn12zbvh NOSHOW
- @ 2.846,33.600 SAY "Output:" ;
- FONT "MS Sans Serif", 8 ;
- STYLE "BT"
- @ 2.846,4.800 SAY "Print:" ;
- FONT "MS Sans Serif", 8 ;
- STYLE "BT"
- @ 4.692,7.200 GET m.p_recs ;
- PICTURE "@*RVN \<Current Record;\<All Records" ;
- SIZE 1.308,18.500,0.308 ;
- DEFAULT 1 ;
- FONT "MS Sans Serif", 8 ;
- STYLE "BT"
- @ 4.692,36.000 GET m.p_output ;
- PICTURE "@*RVN \<Printer;Pre\<view" ;
- SIZE 1.308,12.000,0.308 ;
- DEFAULT 1 ;
- FONT "MS Sans Serif", 8 ;
- STYLE "BT"
- @ 10.154,16.600 GET m.prnt_btn ;
- PICTURE "@*HT \<Print;\<Cancel" ;
- SIZE 1.769,8.667,0.667 ;
- DEFAULT 1 ;
- FONT "MS Sans Serif", 8 ;
- STYLE "B"
- ACTIVATE WINDOW _qjn12zbvh
- READ CYCLE MODAL
- RELEASE WINDOW _qjn12zbvh
- RETURN
-
- PROCEDURE wizerrorhandler
- * This very simple error handler is primarily intended
- * to trap for General field OLE errors which may occur
- * during editing from the MODIFY GENERAL window.
- WAIT WINDOW message()
- RETURN
-
- PROCEDURE edithand
- PARAMETER m.paction
- * procedure handles edits
- DO CASE
- CASE m.paction = 'ADD'
- SCATTER MEMVAR MEMO BLANK
- CASE m.paction = 'SAVE'
- INSERT INTO (ALIAS()) FROM MEMVAR
- CASE m.paction = 'CANCEL'
- * nothing here
- ENDCASE
- RETURN