HPlogo ALLBASE/SQL Reference Manual > Appendix C Sample DBEnvironment

PurchDB.Parts Table

MPE documents

Complete PDF
Table of Contents
Index

E0300 Edition 9 ♥
E0399 Edition 8
E0897 Edition 7


 select * from purchdb.parts;
 ----------------+------------------------------+--------------
 PARTNUMBER      |PARTNAME                      |SALESPRICE
 ----------------+------------------------------+--------------
 1123-P-01       |Central Processor             |        500.00
 1133-P-01       |Communication Processor       |        200.00
 1143-P-01       |Video Processor               |        180.00
 1153-P-01       |Graphics Processor            |        220.00
 1223-MU-01      |Cache Memory Unit             |         80.00
 1233-MU-01      |Main Memory Unit              |        300.00
 1243-MU-01      |Extended Memory Unit          |        100.00
 1323-D-01       |Floppy Diskette Drive         |        200.00
 1333-D-01       |Slimline Diskette Drive       |        200.00
 1343-D-01       |Winchester Drive              |       2000.00
 1353-D-01       |Standard Drive                |       1300.00
 1423-M-01       |Video Monitor                 |        340.00
 1433-M-01       |Graphics Monitor              |        650.00
 1523-K-01       |Keyboard                      |        200.00
 1623-TD-01      |Tape Drive                    |       1800.00
 1723-AD-01      |Graphics Monitor Adapter      |        240.00
 1733-AD-01      |Monochrome Displ/Prt Adapter  |        250.00
 1823-PT-01      |Graphics Printer              |        450.00
 1833-PT-01      |Color Printer                 |       1995.00
 1923-PA-01      |Printer Adapter               |         75.00
 1933-FD-01      |Fixed Disc Adapter            |        590.00
 1943-FD-01      |Plotter Adapter               |        600.00
 ---------------------------------------------------------------------
 Number of rows selected is 22
 U[p], d[own], l[eft], r[ight], t[op], b[ottom], pr[int] <n>, or e[nd]>




PurchDB.Orders Table


PurchDB.Reports Table