HTML publishing and Internet tools

Paradox allows you to harness the power of the Internet in a few simple steps.

You can easily publish dynamic and static reports and tables to the Internet using the Paradox HTML Publishing Experts. You can also create static HTML documents from Paradox forms. Static documents are generated at the time they are saved with the HTML extension. Dynamic documents are generated each time they are requested by a browser.

The Corel Web Servers are fully functional Web servers that act as an intermediary between Web browsers and compatible applications, such as IntraBuilder and Paradox, to transfer requests and responses between them.

Use the Corel Web Server (.EXE) for simple, straightforward Web publishing. Use the Corel Web Server Control if you want to program the server to send custom responses to browser requests or process information posted by electronic forms.

In this section, you'll learn about

  HTML publishing in Paradox
  
  working with the Corel Web Servers
  
  Inserting hyperlinks
  
  importing HTML data
  
For more information about HTML publishing and Internet tools, see Reference: HTML publishing and Internet tools.

HTML publishing in Paradox

You can publish Paradox tables and reports as HTML either statically or dynamically on the World Wide Web. Appropriate HTML tags and parameters are automatically included, and you can then modify the resulting HTML as you would any other HTML document. Static documents are generated at the time they are saved with the HTML extension. Dynamic documents are generated each time they are requested by a browser.

You can also publish Paradox forms as static HTML documents. This works best with simple forms that use text, edit boxes, list boxes, option buttons, or check boxes. Form objects such as graphics, table frames, crosstabs, and notebooks do not translate statically to HTML.

To publish a table to HTML

1	With a table open, Click File  Publish to HTML.

2	Follow the steps in the HTML Table Expert.

Note

  The Corel Web Servers are case-sensitive, so, for future reference, make sure you note the exact filename used when saving documents.
  
To publish a report to HTML

1	With a report open, click File  Publish to HTML.

2	Follow the steps in the HTML Report Expert.

Notes

  Any information in the Page band of a report is not published by the HTML Expert. In order for information contained in the Page band to be viewable in an HTML document, it must be placed in the Report Band of the Report. Since pages are not supported by HTML, page numbers are ignored regardless of where they are placed. For more information on report bands, see Report bands.
  
  The Corel Web Servers are case-sensitive, so, for future reference, make sure you note the exact filename used when saving documents.
  
To publish a form to HTML 

1	With a form open, click File  Publish to HTML.

2	Type a filename in the File name box.

3	Choose .HTM from the Save as type list box.

4	Click Save.

Paradox saves an HTML version of your form that can be viewed by a Web browser. The Corel Web Servers are case-sensitive, so make sure you note the exact filename used when saving documents for future reference.

Notes

  Paradox automatically adds FORM METHOD and ACTION tags to any form published to HTML. By default, the FORM METHOD tag is set to POST and the ACTION is set to the Paradox form object's noise name (for example, #Form1). To set these properties yourself, change the HTMLMethod property or the HTMLAction property of the form using the Object Explorer.
  
  Paradox also adds a Submit button to static forms published to HTML. For the Submit button to work with the Corel Web Server Control, you must add code to trap the POST action in the OnPostRequest event.
  
Working with the Corel Web Servers

The Corel Web Server (.EXE) and related documentation are included when you install Paradox. The Setup program also copies the Corel Web Server Control (WEBSRV.OCX) and supporting DLLs into appropriate directories and registers them.

You can set up the Corel Web Server for simple, straghtforward Web publishing. You can also add the Corel Web Server Control to a form if you want to program the server to send custom responses to browser requests or process information posted by electronic forms.

Once you have set the server properties, you can then start the Corel Web Server, test it, and view connections to it.

To set up the Corel Web Server (.EXE)

  Click Start  Paradox  Utilities  Corel Web Server.
  
The Corel Web Server icon displays on the Windows taskbar. It is active and ready to receive browser requests.

Note

  Your computer must have a TCP/IP protocol installed for the Corel Web Server to function properly. Consult your Windows documentation for details on installing a TCP/IP protocol on your system.
  
To add the Corel Web Server Control to a form

1	With a form open in the design window, click the Corel Web Server Control button on the ActiveX Control toolbar.

2	Drag over the spot on your form where you want to add the Corel Web Server Control.

Note

  Your computer must have a TCP/IP protocol installed for the Corel Web Server Control to function properly. Consult your Windows documentation for details on installing a TCP/IP protocol on your system.
  
To set Corel Web Server properties

To set properties for	Do the following

The Corel Web Server (.EXE)	Right-click the Corel Web Server icon on the Windows taskbar, and click Properties. 

The Corel Web Server Control	Right-click the Corel Web Server Control object, and click Properties  Corel Web Server Control.

Notes

  The Base Path and Default Page properties on the Web Server Properties dialog box Pages page must be set for the Web Server to function properly.
  
  For more information about Corel Web Server Control properties, see About Corel Web Server Control properties or for more information about Corel Web Server properties, see Corel Web Server (.EXE).
  
To start the Corel Web Server

To start	Do the following

The Corel Web Server (.EXE)	Click File  Startup.

The Corel Web Server Control	Run a form containing a Corel Web Server Control object.

Note

  The Web Server must be active in order to process requests from browsers. The Corel Web Server (.EXE) is started in an active state, however, it can be shut down without exiting the Server.
  
To test the Corel Web Server

1	Start your Web browser.

2	Type your computer name as the address to locate.

The page you specified in the Web Server Base Path property is displayed by the browser.

Notes

  If you don't know your computer name, consult your Windows documentation.
  
  The Corel Web Servers are case-sensitive. Be sure to use exactly the same filename you specified in the HTML Publishing Expert.
  
To view Corel Web Server connections

To view	Do the following

Connections to the Corel Web Server (.EXE)	Right-click the Corel Web Server icon on the Windows taskbar, and click View Connections.

Connections to the Corel Web Server Control	View the Paradox form containing the Corel Web Server Control object.

Inserting hyperlinks

Hyperlinks to the Internet can be inserted as data in form and table fields or as static design objects. When you click a hyperlink, Paradox uses the appropriate Internet protocol to follow the links. For example, HTTP it will launch the default browser to display the Web Site, and MAILTO it will open a new message in the default mail program.

Paradox supports the following Internet protocols for hyperlinks: HTTP, FTP, MAILTO, GOPHER, NEWS, TELNET.

To insert a hyperlink in a field

  Type the URL in an alpha field.
  
To insert a hyperlink as a design object

1	With a form open in the design window, place a new text object on the form.

2	Follow the steps in the Text Expert.

3	 In the third Text Expert dialog, enable the Hyperlink option.

3	Type the URL in the Hyperlink box. 

4	Click Finish.

5	Run the form to activate the hyperlink.

Notes

  Include the appropriate protocol for the hyperlink (e.g., HTTP://, FTP://).
  
  You do not have to use the actual URL as the text to be linked. Whatever text you type in will be linked to the URL specified.
  
Importing HTML data

You can import tables or lists from HTML files into Paradox tables. The data can be added to an existing table or used to create a new one.

To import data from an HTML file

1	Click File  Import.

2	Click HTML Expert.

3	Follow the steps in the HTML Import Expert.

Reference: HTML publishing and Internet tools

This section contains reference informationpertaining to HTML publishing and Internet tools.

HTML Output

When you publish tables, reports, or forms in HTML, the following will occur:

Field/Object	Output

Memo and formatted memo 	Direct output, but all formatted information (bold, underline, font, and so on) is ignored

Table frame 	Converted into tables

Multi-record 	Converted into tables

Graphic	Images converted to .JPEG file format

OLE	Not supported

Binary	Not supported

Bytes	Not supported

Calculated field	not supported

Line	Not supported

Ellipse	Not supported

Chart 	Not supported

Crosstab	Not supported

About HTT files

An .HTT (HyperText Template) file is an HTML file with custom metatags. These tags are Paradox-specific, and are used by the HTML Publishing Engine to produce standard HTML files. Conceptually, an .HTT file is an intermediary step in the Internet publishing system; all layout information is defined but metatags are used in place of tables, queries, and other database objects.

HTT files are generally used in dynamic publishing where the layout information is known but the actual data needs to be resolved at run time. The dynamic publishing of the Corel Web Server (.EXE) manages .HTT files automatically, so their existence and function are largely transparent to the user. If you are implementing your own dynamic publishing system with the Corel Web Server Control, you can generate .HTT files using File, Publish to HTML for tables, reports, and forms.

HTT files are contained in the Web Server Repository, a storage facility for HTML template files created by the Paradox HTML Publishing Experts and used by the Corel Web Server Control and the GXEngine to produce dynamic HTML files on browser requests. To view a list of stored templates and their contents, click Tools  Web Server Repository. 




