BWS40 v4.2 June 1998
Copyright 1998 Business Software (UK) ebinfo@compuserve.com.

DEMONSTRATION FILES
-------------------
This file contains information on using the demonstrations included with BWS40 build date June 1998 or later. If you do not have the demonstration files with your copy of BWS, then the package has been distributed in breach of the shareware distribution agreement included with this package. Please request the full package from your distributor, or contact Business Software at 

ebinfo@compuserve.com.
-----------------------------------------------------

To use the Demonstrations included with this Application:=

Open the Explorer Bar by selecting FILES|EXPLORER BAR from the main menu, or clicking the leftmost button on the tool bar.

Double click the 'Views' branch. You should now see several *.viw files as children of the view branch. Each of these 'views' present a simple demonstration of some of BWS's capabilities. Later, you will learn how to save your own setting snapshot in a VIW files, which you can recal at any time with a couple of clicks!

1.DEMO.VIW
=======================================================

Double-click 'DEMO.VIW'

When the files have finished loading, you may close the explorer bar by the same way you opened it.

The grid displays a fictional table called 'INVOICES.DBF'

Click on a cell in the column labelled NET VALUE. The cell is now open in  Edit Mode.

Right-click, and select 'Properties' from the pop-up menu. Properties for the field are displayed.

Right-click on the 'NOTES' column, and select 'Display'. The memo field is opened in a sizeable window for viewing/editing. Click back on the grid, and cycle through the various records; the contents of the memo window reflects the contents of the memo field for the selected record. Any number of windows may be opened simultaneously, one for each memo field. A similar window is available for Graphics fields.

Right-click on one of the DATE fields, and click DISPLAY again. A pop-up calender appears to assist with editing date fields. Right-click on the calender for more options.

Restore (NOT Maximize) the two minimized icons labeled 'NO' and 'CUST'.
Move them to a convenient position away from the grid details. You may notice that these are in effect DETAIL tables attached to the INVOICES table via 'local' columns 'CUST' and 'NO' linking to their respective 'foreign' columns of the same name. Change the selected record in the main grid, and note that details follow.

Focus on the detail table with the caption 'NO'. Select the column labelled 'PRODNO'. Right-click, and select 'detail' from the pop-up menu. Notice a further detail window opens on screen, with the caption 'PRODNO'. Open the left-hand combobox of this window, and select 'PRODUCT.DBF' table. This table contains an itemised list of products, prices, and descriptions. Open the right-hand combobox, and select 'PRODNO' (the only choice) as the 'foreign' index. You now have a three-level master-detail open on screen...

  INVOICES.DBF-->DETAILS>DBF-->PRODUCT.DBF

..as well as the INVOICES.DBF-->CUSTOMERS.DBF relationship! Master - details may be nested to arbitrary levels.

Open the Organiser by selecting FIELDS|ORGANISE from the main menu, or clicking the ninth button from the left on the toolbar. Press F1 for more information on using the organiser to rearrange, format, and display your columns. Close the organiser by clicking the check button.

Open the Report Setup Wizard by selecting FILE|REPORTS from the main menu, or clicking the fourth button from the left.
Open each tab in turn, to view the options available, but do not alter anything at this stage. Click the HELP (?) button to learn more about the Report Generator Setup Wizard.
Click the 'Print to Screen' speedbutton (third from left, with 'monitor' icon) to preview the currently set up report on the screen.
Close the preview window with the system button (X) to return to the Wizard.
Click the Print speedbutton (printer icon, second from left) to send the report to the printer via the usual dialog box.
Close the Wizard with the check-mark button. Settings are saved.
 
Right-click on the grid, and select Indexes - the slide tray indicates the available indexes for the table. Place the cursor on the 'Net value Column. Click INDEXES|ADD|NET>ASCENDING on the main menu, and confirm the ADD INDEX dialog by clicking the check-mark. Now select indexes again from the pop-up menu, and note that NET has been added to the list.
Press F1 whilst the ADD INDEXES DIALOG is open for more information on adding indexes, and using Dbase expressions.

2. SQLDEMO.VIW
========================================
Load this demonstration by double-clicking the SQLDEMO.VIW filename in the Explorer Bar. 

This demo shows how several tables can be linked in a JOIN, and the resulting 'mess' organised by BWS to produce a set of printed invoices.
The tables used in the join are

    1. INVOICES.DBF
    2. DETAILS.DBF
    3. PRODUCT.DBF
    4. CUSTOMER.DBF

BWS's Fields Organiser has been used to rearrange the field display (index) order, to hide unwanted fields from view (and printing), to format the numerical fields to currency style where required, and to label each field with a more esoteric label. Click the Organiser (FIELDS|ORGANISE from the main menu, or the toolbar speedbutton) to see the way this was done.

BWS's Report Generator has been set up to print the resulting layout as a set of invoices, showing the customer's name and address in the header (even though these fields were hidden from view in the grid, they are still available for other operations as needed). Click the Preview button ('Monitor' icon, third from left) to view the pages of this report in WYSIWYG. Use the 'VCR' style controls on the preview screen to navigate through the ten pages of the report. Close the preview screen with the system close button [X] to return to the report setup. Click the Page Tabs of the Report Setup Wizard to view the settings used to produce this report. Note how Table Breaks, Break Triggers, Break Sum, and Eject Page are used to format the reports as one invoice per page, and system and field variables are used in the header to produce a mailing address for window envelopes, and incorporate issuing company details. Click the help button (?) to learn more about producing stunning reports with BWS. Close the Report Wizard by clicking the check marked button: the settings are preserved.

Open the SQL Editor by selecting MODE|SQL from the main menu, or clicking the SQL button on the toolbar (seventh button from left). The Editor contains the SQL query used to select and join the necessary tables. Click the Help Button [?] to learn more about using local SQL. Click the close button [X] or use the system menu to close the Sql editor.


3. HTMLDEMO.VIW
=========================================
Load this demonstration by double-clicking the HTMLDEMO.VIW filename in the Explorer Bar. 

This demo shows how BWS can be used to generate a HTML table from tabular data.

Only one table is used in this case, consisting of four fields made up of

Field 1:IMGSRC - a character field containing the name of a bitmap file in the default directory.
Field 2:URL - another character field containing a list of Internet site URLs.
Field 3:TARGET - the respective site titles of the URLs in field 2.
Field 4:DESC - A description of each of the sites referred to in field 2.

OPEN the HTML Setup by either selecting FILE|HTML from the main menu, or clicking the HTML button on the tool bar (fifth from left).

Generate a HTML page from the loaded table and supplied HTML Tags by clicking the left-most button on the speedbar, and supplying a suitable name. 

Open your Browser (NETSCAPE & INTERNET EXPLORER ONLY SUPPORTED!) by clicking the browser button (fifth from left). Your default browser will open with the page you just saved as the default. Return to BWS (alt-tab), make some changes to the setup, (say, change the background color by double-clicking the 'BGColor' section value in the left-most grid, and selecting a new color from the color dialog box). Now save the page again by clicking the left-most button on the speedbar. View your handiwork by switching to your browser, and click 'REFRESH' to re-load.

Note how the LINK TYPE properties have been used to incorporate the images into the table, to hide the URL field, and to use the TARGET field as a HotSpot.

Click the Help button [?] to learn how to generate HTML pages from your tables, and even multi-join SQL result sets. When your externally maintained data changes, it is a simple matter to regenerate the page!

NOTICE THAT ALL OF THESE DEMOS HAVE BEEN LOADED FROM *.VIW FILES. THESE FILES ARE SNAPSHOTS OF THE CURRENT SETTING YOU USE IN BWS, AND MAY BE SAVED AT ANY STAGE. SEE THE HELP FILES FOR INFORMATION ON STORING AND OPENING VIEW FILES.

4. INPFORM.VIW
=========================================
Load this demonstration by double-clicking the INPFORM.VIW filename in the Explorer Bar. 

This demo shows how BWS can be used to generate a HTML FORMS from tabular data.

OPEN the HTML Setup by either selecting FILE|HTML from the main menu, or clicking the HTML button on the tool bar (fifth from left).

Generate a HTML page from the loaded table and supplied HTML Tags by clicking the left-most button on the speedbar, and supplying a suitable name. 

Open your Browser (NETSCAPE & INTERNET EXPLORER ONLY SUPPORTED!) by clicking the browser button (fifth from left). Your default browser will open with the page you just saved as the default. Return to BWS (alt-tab), make some changes to the setup, (say, change the background color by double-clicking the 'BGColor' section value in the left-most grid, and selecting a new color from the color dialog box). Now save the page again by clicking the left-most button on the speedbar. View your handiwork by switching to your browser, and click 'REFRESH' to re-load.

A HTML Input Form has been produced from the layout specified in the stored table, and the formatting instructions entered in the HTML Designer fields. If you substitute a valid E-mail address ( try your own!) and remember to regenerate the form and "refresh" the browser page after each modification. Fill in the details on the form, click "Submit" and the form will be forwarded to you by e-mail.

Click the Help button [?] to learn how to generate HTML pages from your tables, and even multi-join SQL result sets. When your externally maintained data changes, it is a simple matter to regenerate the page!

NOTICE THAT ALL OF THESE DEMOS HAVE BEEN LOADED FROM *.VIW FILES. THESE FILES ARE SNAPSHOTS OF THE CURRENT SETTING YOU USE IN BWS, AND MAY BE SAVED AT ANY STAGE. SEE THE HELP FILES FOR INFORMATION ON STORING AND OPENING VIEW FILES.


(c) Business Software 1998.

=========================== end of DEMO.TXT =============================
