SQLData Systems, Inc.
Home | Products | Services | Documents | Support

Getting Started

Frequently Asked Questions

Documents

 

 

Here are some of the general procedures for using the SQLData server.

1. How to create a new report?

     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:
bulletClick My Report link on the top of a HTML page. This bring up the report editor.
bulletClick the Add New button at the bottom of the page to add a new record.
bulletType in REPORT as the LogicType and enter a unique report name as LogicName. The report name will be used for referencing  the report.
bulletEnter a brief description for the report. The description is displayed in the report list.
bulletType in the SQLStatement to be executed when users select the report. This should be a SQL select statement.
bulletClick the Add New button to add the report.

2. How to create my own stored procedure?

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:
bulletUse PROCEDURE as the LogicType.
bulletSQL statement can be any SQL statement including query.

 

3. How can I use reports and procedures in my own HTML files?

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.

4. How to create data dictionary?

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:

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

5. Can I create my own HTML pages with database contents?

Yes.  You can create your own HTML pages and plug in  data from databases. Here is how:
  1. Create your HTML page using any authoring tool.
  2. 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.

 

 

     

 

     

 

     

 

     

 

     

 

     

 

     

 

     

 

     

 

 

 

Download | Purchase | ContactFeedback

horizontal rule

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