Using the Schema Editor

The Schema Editor is used with the Connector object.

 

The Schema Editor is used to configure your tables and variables. These values only need to be configured in the Schema Editor and will be stored so they can be selected in the SQL and Expression Wizards.

 

 

 

The tables you add on the DB Schema tab will be used to build a recordset. After adding a table, you will need to determine which data fields from that table you want to pull records from to form your recordset. The order in which you add your tables and fields is not important in the Schema Editor - by default, the sorting will be done in alphabetical, ascending order unless otherwise specified in the Recordset Properties Palette. There is no limit to the number of tables and fields you can add in the Schema Editor.

 

On the Variables tab, you can define the following variable types:

 

  • URL Parameter:

Variables reflecting parameters appended to a URL.

  • CGI Environment:

Variables reflecting the CGI environment variables of the context of the requested template.

  • Form:

Variables reflecting the values of the fields in a form submitted to the current template.

  • Client:

Variables used to associate data with a specific client.

  • Session:

Variables used to associate data with a given client session.

  • Server:

Variables used to associate data with a given client session.

  • Application:

Variables used to associate data with a specific application.

  • Cookie:

Variables reflecting cookies passed by the requesting browser.

 

Note that you must first add a Data Source in the properties palette before you can configure the tables and variables.

Next

Double-click in the Schema Editor

 field to open the editor.