home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Shareware Overload
/
ShartewareOverload.cdr
/
database
/
pbase.zip
/
EDITFORM.PRG
next >
Wrap
Text File
|
1985-10-03
|
2KB
|
100 lines
* EDITFORM.PRG (10-03.a)
* usage: editform <table-name>
* cursor and form definition must be preset
FORM HEADING '[ Add/Search ]'
FORM SHOW TEXT
FORM SHOW FIELD ALL
DOWHILE true
SHOW MESSAGE 'Enter data: F2 - OPTIONS'
FORM READ FIELD ALL
DOCASE
* <F2 - options>
CASE KEYPRESS()=316
DOMENU
MENUTITLE '[ Add/Search Options ]'
MENUOPTION 'Search'
MENUOPTION 'Add'
MENUOPTION 'Quit'
MENUCHOICE choice
ENDMENU
DOCASE
* <search>
CASE choice=1
FORM SELECT FROM &1
DROP FORM
FORM HEADING '[ NEXT, UPDATE, DELETE, ADD ]'
FORM SHOW TEXT
FORM SHOW FIELD ALL
SHOW MESSAGE 'Modify data: F2 - OPTIONS'
ASSIGN 1 TO _editfet
DOWHILE true
IF _editfet=1
FETCH
IF ISEOF()
CREATE WINDOW 1 3 45 1 30 112 1 '[ End of Fetch ]'
USE WINDOW 1
PAUSE
DROP WINDOW 1
EXIT
ENDIF
FORM SHOW FIELD ALL
ENDIF
FORM READ FIELD ALL
DOCASE
* <F2>
CASE KEYPRESS()=316
DOMENU
MENUTITLE '[ Search Options ]'
MENUOPTION 'Next'
MENUOPTION 'Update'
MENUOPTION 'Delete'
MENUOPTION 'Add'
MENUOPTION 'Return to Search '
MENUCHOICE choice
ENDMENU
DOCASE
* <next>
CASE choice=1
* <update>
CASE choice=2
FORM UPDATE &1
EXIT
* <delete>
CASE choice=3
FORM DELETE FROM &1
EXIT
* <add>
CASE choice=4
FORM INSERT INTO &1
EXIT
* <search again>
CASE choice=5
EXIT
OTHERWISE
ASSIGN 0 TO _editfet
ENDCASE
OTHERWISE
SOUND
ENDCASE
ENDWHILE
FORM CLEAR FIELD ALL
DROP FORM
FORM HEADING '[ ADD, SEARCH ]'
FORM SHOW TEXT
FORM SHOW FIELD ALL
* <add>
CASE choice=2
FORM INSERT INTO &1
FORM CLEAR FIELD ALL
* <return to caller>
CASE choice=3
CLEAR MESSAGE
DROP VARIABLE LIKE '_???????'
EXIT
ENDCASE
OTHERWISE
SOUND
ENDCASE
ENDWHILE