home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Shareware Overload
/
ShartewareOverload.cdr
/
database
/
disk_20.zip
/
NUDBMSX.ZIP
/
VALUES.PRG
< prev
Wrap
Text File
|
1987-01-27
|
1KB
|
52 lines
***** Program: VALUES.PRG *****
SET TALK OFF
SET ECHO OFF
DO WHILE .T.
CLEAR
?
?SPACE(32)+"VALUE of Stock Items"
?
?
?SPACE(10)+" Stock No. Model Quantity Unit Cost Total Value"
?SPACE(10)+"----------- ----------- -------- --------- -----------"
SELE 1
USE STOCKS
SELE 2
USE COSTS
TOTALUNITS = 0
TOTALVALUE = 0
DO WHILE .NOT. EOF()
SELE 1
STOCKNO = STOCK_NO
SELE 2
LOCA FOR STOCK_NO = STOCKNO
COST = OUR_COST
SELE 1
VALUE = COST * ON_HAND
? space(10)+ stock_no+' '+model_no+' '+str(On_hand,5,0)
??STR(COST,14,2)+ STR(VALUE,13,2)
TOTALUNITS = TOTALUNITS + ON_HAND
TOTALVALUE = TOTALVALUE + VALUE
SKIP
ENDDO
?space(38)+'---'+space(19)+'--------'
?space(21)+'Total'+space(10)+str(totalunits,5,0)+space(14)
??STR(TOTALVALUE,13,2)
?space(38)+'==='+space(19)+'========'
?
?
SET PRINT OFF
?" [P] Print Reports [Q] Return to main menu"
WAIT " " to choice
DO CASE
CASE upper(choice) = "P"
SET PRINT ON
LOOP
CASE upper(choice) = "Q"
RETURN
OTHERWISE
LOOP
ENDCASE
ENDDO
RETURN