DataMuseum.dk

top - metrics - download

    Length: 3615 (0xe1f)
    Types: TextFile
    Notes: UNIX file
    Names: »cars.branch«

└─⟦c93a30372⟧ Bits:30004169/disk3.imd Uniplex II+ V.6 release 1.0 (dansk)
└─⟦c93a30372⟧ UNIX Filesystem
    └─⟦this⟧ »up/new/usr/UAP/demo/us_sales.frm/src/cars.branch« 

TextFile

:C U.S. Version
:TITLE
--  CARS-BRANCH INQUIRY  --
:TABLE
car_type
:SCREEN


            DAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAF @@
            [[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[
            B This forms allows searches for branch from either B@@
            [                                                   [
            B the make, model or car id of a vehicle.           B@@
            [                                                   [
            B                                                   B@@
            [[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[ [
            B Make           : [l-make______]                   B@@
            [                                                   [
            B Model          : [l-model___]                     B@@
            [                                                   [
            B Car id code    : [l-id__]                         B@@
            [                                                   [
            B                                                   B@@
            [                                                   [
            B License        : [reg_____]                       B@@
            [                                                   [
            B                                                   B@@
            [[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[
            B Current driver : [l5_________] [l6_________]      B@@
            [                                                   [
            B Current branch : [l7_] [branch-name_]             B@@
            [                                                   [
            JAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAH @@
            [[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[
:LABELS
:C This section specifies the details for the three input fields
:C Make equaks Ford, Vauxhall etc
:C Model equals Escort, Cavelier etc
:C Car_id is the database code for the car 001, 002 etc

l-make =Make,   type char;
l-model=Model,  type char;
l-id   =Car_id, type char;

:LABELS
:C This refer searches the table 'cars' for a car where the column
:C 'Car_id' in 'cars' is equal to the current value in label 'l-id'
:C The output from this search is the column 'Car_reg' and this value
:C is placed in the label 'reg'.
table=cars
search on Car_id=l-id;
reg=License

:LABELS
:C This second refer searches the table 'sales_force', for a driver of
:C the selected car, i.e. where the column 'Car_reg' in 'sales_force'
:C is equal to the value in the label 'reg'
:C The output from this search goes into three fields:
:C l5 = the first name of the driver
:C l6 = the surname of the driver
:C l7 = the branch number the driver works at.

table=sales_force
search on License = reg;
l5=First_name;
l6=Surname;
l7=BNo

:LABELS
:C This final refer searches the table 'branch' to get the town name
:C for the branch code as found from the refer above.

table=branch
search on BNo =l7;
branch-name=Branch_name

:HELP
        any text you care to enter



:END

Any text that appears after the ':END' section is ignored.

This is primarily used for adding extensive comments and documentation to
the end of a customised form.  As a general note it is always worth
adding as much commentary to a form as possible.  You may understand
why the forms is built this way now - but what about somebody else
looking at the form in five years time?

Further it is possible to keep a complete duplicate of a form after
the end so that a record is kept of an original form prior to making
any amendments.