EAStudio includes a demo PowerDynamo website that uses the HTML DataWindow. The website is in the EAS Demo DB V3 database.

• To run the demo website:

1. Install PowerDynamo and Jaguar on the same machine
2. Start the PowerDynamo Personal Web Server.
3. Start the Jaguar server (described in "Configuring the Jaguar server to use the HTML DataWindow server component").
4. In your web browser, type the URL:

http://localhost/EASDemo/htmldw/main.htm

If you have both Microsoft Internet Explorer 4 and Netscape Navigator 4, view the web page in both browsers to see the difference in the display. Netscape doesn't support absolute positioning, so the rendering doesn't look as good.

5. Interact with the DataWindows. For example:
6. Click a department manager in the right column. A detail DataWindow appears in the upper right frame.
7. Click a department in the upper left DataWindow. An employee listing for that department displays in the bottom frame.
8. In the employee listing, view the state dropdown DataWindow and notice the display formatting for salaries.
9. In the employee listing, change a salary or birth date. Validation rules for these columns require that the salary be greater than 20000 and the birth date be earlier than today.
10. Choose a raise percentage or change a salary and notice that the computed field on the right changes too. However, the salary totals at the bottom don't change until the page is reloaded because they use aggregate functions that must be computed on the server.
11. Use the buttons to add new rows, update data, and view additional pages of data.

• To view the files for the demo website in Sybase Central:

1. Start Sybase Central on Windows.

You can choose either Sybase Central in the Sybase program group or Manage Power Dynamo in the PowerDynamo 3 program group.

2. Select Tools>Connection Profiles from the menu bar.
3. In the Connection Profile dialog, highlight EAS Demo and click Connect.

If the EASDemo profile does not exist, you can create it. Select PowerDynamo 3.0 as the Type, ODBC as the Connection Type, and EAS Demo DB V3 as the DataSource.

4. In the left pane, expand the EAS Demo folder and the HTMLdw folder to find the HTML files for the website. Double click files to open them in the editor and view their scripts. In PowerBuilder or DataWindow Builder, examine the DataWindows for the website. The PBL is installed in the Sybase\Shared\PowerBuilder path:

PBL ssv_dw_reserve.pbl

Application htmldw_dw_examples

DataWindow objects d_dept_listing, d_emp_in_dept, d_employee_detail, plus DataWindow objects for dropdown DataWindows          

Other objects in the PBL are part of the SurfSide Video demo application.