 |
dBworxPE Help File |
 |
Design |
 |
Special Field Types |
 |
Operation |
 |
Listings, Reports and Labels |
 |
Templates |
|
|
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".
|