The first thing you need to do before creating a SQL sentence and use it in a DBSP page, is to create and correctly configure a connection. You can find more information about this in the section: Configuring the database connection. Once you have configured and tested successfully you connection you are ready to start.

Running the DBSP Builder

Open the application using the following steps:

Start -> Programs -> DBSP -> DBSP Builder

The application interface looks like the following snapshot (Press in the snapshot for a full image).

Connecting to the database

1. In the application menu, click on Database -> Available connections or press Ctrl-Alt-C. If the Current connection file box is empty, select your connection file (normally c:\dbsp\bin\dbsp.dbc) by pressing the select button (...).

Your window show look like this:

Remember that you need to have a previously configured connection. For more information about this topic see the section: configuring the database connection.

2. Select the connection that you want to use and press the Ok button.

First time connection: Table creation

The DBSP engine needs two tables in order to store and organize the DBSP objects. These tables are the DBSP_OBJECTS table and the DBSP_CATEGORIES table. In the first time you connect successfully to the database, you will receive a message like the following one:

If you press the OK button, DBSP will try to create the tables automatically and after that you can continue normally with the creation of DBSP objects.

In order to successfully create the tables, take in mind the following considerations:

• The database user configured in the connection must have table creation privileges. After the tables were successfully created, you can remove this privilege to the user.
  
  
• Be sure that the database user has reading/writing privileges over the tables that you are planning to use. These privileges could be established according the operations that you wish to execute over each table used by the system.
  
  

Creating object categories

DBSP helps you to have a better organization of your database objects, so each of these objects needs to be created under a certain category. These categories are displayed in the DB objects pane at the left of the Interface. Select this pane to see the connections and their categories.

In order to create a new category, follow these steps:

1. Right click the connection available on the DB objects pane and click Add category. The add category window displays.

2. Type the name for the new category, for example "Test"

Now the new category is created. You can delete or modify the category name by right clicking it and selecting the desired operation from the context menu.

Creating a SQL sentence

Let's now create a new SQL sentence.

1. Select the category and press Ctrl - U for creating a new object.

2.Type a name for the sentence, the author's name and if you want a reference.

3. Press the OK button. The SQL Editor window appears.

Look at the title of the window. I has an integer number at the left side of the sentence name. This will be the identification number for this sentence further known as the QUERYID number. Type the SQL Sentence inside the SQL editor.

You can test the result of your SQL sentence by clicking in the results tab or pressing Ctrl - Enter.

These are the basic concepts related to the construction of SQL Sentences. In the next section, you will learn how to use this sentence inside a DBSP Page.

Previous | Next