Home
dBworxPE Online Help Prev Page Prev Page
dBworxPE Help File
Overview
Features
Register
Paging
Design
Basics
Field Types
Special Field Types
External Fields
Graphics Fields
Formula Fields
Lookup Fields
Relational Fields
Examples
Operation
Navigation
Add/Edit/Delete Records
Webforms
Smart Forms
Searching
Sorting
Filtering
Action Menu
Saving
Backup/Restore
Keyboard Reference
Text/HTML Editor
Listings, Reports and Labels
Listings
Labels
Reports/Documents
Print/View Document
Print/View Report
Pie Charts
Import
Export
XML import/export
PDA import/export
Macros
Programming
Create web page
Connect to Database
Viewer
Templates
Entry Templates
Application Templates
Tools
Network/Multi-user
FAQ
Other Plworx products
License
Contact
EXAMPLES:

dBworxPE comes with a number of sample files (located in the 
"examples" sub-directory).  Each of these files is intended to provide
an example of one or more of the field types available in dBworxPE.
The samples include:

  1) "contax"
     A general purpose 'contacts' database which you can use to
     experiment with adding, editing, and deleting records, sorting,
     filtering, and so on.
  
  2) "sample"
     Includes memo, external, and graphic field types.

  3) "sales"
     Demonstrates the use of 'formula' or calculated fields;  notice
     the coding for the 'Sales Amount' and 'Profit' fields.

  4) "invoice"
     An invoice file that shows how to use a code 'J' (subsidiary or
     'joined') field to hold the individual items for each invoice.  
     Notice the 'Value' part of the 'Invoice items' field definition:
          
             Amount>Invoice Total>Quantity>Quantity sold

     You can plug totals from the item records into other fields in
     the invoice record; in this case the total of the 'Amount' field
     in the item records is automatically inserted in the 'Invoice Total'
     field and the 'Quantity sold' total is inserted in the 'Quantity' 
     field of the invoice record.

  5) "timeshet"
     A simple example of using relational (code 'R') fields.  The 
     'Employee Name' field in the time sheet file is coded as a 
     relational field, and the 'Value' portion of the field definition
     is set to:

          Emp No.>c:\dbworx\examples\empfile.dwh  

     (Note: if your example files are installed in a directory other
            than 'c:\dbworx\examples' you will need to change the 
            path shown above in order to get this example to work)

     When you enter a time sheet record dBworx will take the 
     employee number you key in, open the 'empfile' database, search
     for a matching employee number and pull the employee name
     from that particular 'empfile' record if it finds a match.  Notice
     that the 'key field' (employee number in this case) that dBworxPE
     is going to use to locate the correct record in 'empfile' has to   
     come before the employee name field.

  6) "lookup"
     An example of a type 'L' (lookup) field.  If you're adding (or
     editing) a record, then when you come to 'Employee Name', if 
     that field is blank dBworxPE will pop up a list of names for you
     to choose from.  (Common examples of this type of field might be
     a list of State names, sales codes, etc.).   

  7) "stockmf" and "stocktrn"  
     These two files are used to demonstrate automatic updating 
     using macro commands.  For more information see the Help file
     section on "Macros".

Browser Based Help. Published by chm2web software.