The All-in-One Database Software Solution

Online Help System

Back to Brilliant Database Web-Site | Write to Support | Help Index

Creating HTML Frames

Introduction

This program allows using a web-window instead of the regular controls:

In this picture, you can see that, instead of the standard folder list and the folder contents, the window displays a Web page specified in the html code. Besides the regular HTML objects (text, links, tables, images, flash, etc.), you can call User Functions to integrate the Web page with a database. For example, by double-clicking a link you can run a query, print a report, run a script, etc for some record.

In the current version, you can define the Web content for the following objects:

Folder list. Select the View > Advanced menu item.
Folder content replacement. Select the HTML Content property in folder properties.

Editing HTML content

It is recommended that you use a special Web-page editing program for creating an html page for your database. Once the Web page is created, copy the code between the <body> and </body> tags to the html-content editor window to add it to the database:

Close the editor, and you will see that the Web page you just created appears instead of the content of the folder:

To make the HTML interactive, use Text Formula Editor. With this editor, you can insert values of database variables, call of user functions, formulas, constants, etc to the content. Here we are going to take a look only at the insertion of a user function call in the code. To learn more about the other operations, please see the Text Formula Editor section.

Adding User Function to HTML content

Before adding a User Function call, we will need to create it with Script Designer. Suppose we have a user function with the Run Report name and a single parameter - report_name. To insert it into the code, click the HTML UF Link... button:

In the displayed window select the user function you have just created and the parameter value (e.g., customers). The following text will be generated:

<!Run Report Unknown block: CUSTOMERS!>Link Text</a>

Replace the Link Text with the text to appear in the user function call link; for example, Checked-In customers. The call of a user function must be completed with the </a> tag. So, our html code now looks as follows:

In the program, the Web page will appear as follows:

Clicking the link will call Run Report with the customers parameter.