The WordPage Datasource

A WordPage Datasource is needed in most WordPage documents that access a database. It provides you with control over the query to issue as well as a list of fields to insert into your document. In your document it looks like this:

 

After a WordPage datasource has been inserted into your document you will see a control that that shows you the name of the datasource and a push button titled “WordPage Options”. If you wish you may change the name of your datasource. All of the examples included with WordPage use the default name “data”. The push button displays a menu allowing you to control all of the options available in a WordPage datasource. These options are:

 

Show Field List

The “Show field list” option displays the “Datasource Field List” which is discussed below.

Edit Query

If  “Manually edited query” is checked then “Edit query” invokes a simple dialog allowing you to directly edit the command that will be issued to the database. If “Manually edited query” is not checked then the dialog for controlling the query that WordPage generates is displayed. This dialog is discussed in the “Editing Query Parameters” section.

Manually Edited Query

“Manually edit query” is a toggle that allow you to select whether you want to fully control the command issued to the database or allow WordPage  to generate it based on information you provide.

 

Note: The advanced features for allowing filter and sort options to be specified in the request are only available if this option is off.

Select Database

“Select database” allows you to pick the type of connection WordPage uses to access your database as well as selecting the specific database. Since WordPage uses ADO to perform database operations many types of data can be accessed.

 

Note: Most types of connections have a check box which enables the password for the connections to be saved in the connection information. This option must be checked for WordPage to have the information it will need to access the database.

Help

The “Help” command invokes the WordPage help system.

About

The “About” option shows you copyright and version information about WordPage.