Help Index

A report is a database query that meets your daily needs. SQLData server allows you to add your own reports so that they can be executed by a simple button click. Reports are stored as part of the business logic in a database table called TableLogic. Here is how you can add your own reports:

	Click My Report link on the top of a HTML page. This bring up the report editor.
	Click the Add New button at the bottom of the page to add a new record.
	Type in REPORT as the LogicType and enter a unique report name as LogicName. The report name will be used for referencing the report.
	Enter a brief description for the report. The description is displayed in the report list.
	Type in the SQLStatement to be executed when users select the report. This should be a SQL select statement.
	Click the Add New button to add the report.

A stored procedure is a group of SQLStatement the server executes as a whole. Stored procedures are part of the business logic stored in a database table called TableLogic. The procedure for adding a procedure is very similar to adding a report with two exceptions:

	Use PROCEDURE as the LogicType.
	SQL statement can be any SQL statement including query.

Reports and procedures can be referenced directly in a hyperlink:

Report: http://yourhostname:8732/record_browser.html?ReportName=NewReport

Procedure:

http://yourhostname:8732/record_browser.html?ProcedureName=NewProc

where NewReport and NewProc are the name of your report and procedure. Record_browser.html is the name of your template file for displaying results.

You can even drag-drop the URL to your desktop for quick executions.

Data dictionary describes fields in a database table and define data type, length and other constraints of the field. SQLData allows you to associate such description to every field in your database. The description will be displayed when user click on the name of the field. This is a very convenient way for providing online assistance to users of your application.

Data dictionary is stored as part of Field Logic in a table named FieldLogic. You can modify the table, as you do with any other tables, by simply click on the name of the table.

Here is a procedure for adding the description of a data field into the data dictionary:

	Bring up the database table in the Record Browser by clicking on the name of your database table (in the left panel of your browser).
	Click on any record in the table. This takes you to the Record Editor.
	Click on the small image on the right of the field name you want to describe. The Logic Editor should show up.
	Enter your description in the Description field of the form and click the Update button.

Yes. You can create your own HTML pages and plug in data from databases. Here is how:

Create your HTML page using any authoring tool.
At the place you want to add database content, insert the following string:
                  [include /include/data_template.html]
where data_template.html is a template file under the include subdirectory and the following file are available:

Record set display     :   browse.html
Add new                       : addnew.html
Edit                                  :    edit.html

We are going to add more such templates in the future. These template files are very simple and easy to create. You can build your own templates using SQLData Template Tokens.

Send mail to info2-at-sqldata-dot-com with questions or comments about this web site.Copyright 2008-2010 SQLData Systems, Inc.Last modified: July 10, 2010

Send mail to info2-at-sqldata-dot-com with questions or comments about this web site.
Copyright 2008-2010 SQLData Systems, Inc.
Last modified: July 10, 2010