Previous Next Contents


ResultSet Property Editor

The ResultSet property editor enables you to provide correct information to complex properties.

This customizer includes the following steps:

Related Topic
Specify DataSet Class
Description
Specify the DataSet to create for this output.

 Properties
Field
Description
DBDataSet
A result set from one or more queries to a relational database.
DBStoredProcedure
The results of a pre-built procedure stored in a relational database.
DataSet
Data set populated by the user. Contains no linkage with a data source.

Related Topic
Specify DataSet Name
Description
Specify the name of the DataSet to create for the output.

 Properties
Field
Value
Example
DataSet Name
Name of the data set.
default00

Related Topic
Specify Procedure
Description
Specify the stored procedure to be called and the connection with which to call it.

 Properties
Field
Value
Example
Statement
Procedure to be called.
{ :ret = call foo(:in_out_arg1, &inarg2) }
Connection
Connection through which the procedure is called.
Create new connection

Related Topic
Specify Data Access
Description
Specify how to define the data used on your forms and reports.

 Properties
Choose one of the following:

Related Topic
Specify Data Model
Description
Specify the data model to use to define your pages.

 Properties
Field
Value
Example
Data Model
You can select a data model found in the current project from the pop-up list or click Browse to locate a data model found elsewhere.
MessageBoard.kdm
Create a new data model
Exit the wizard and create a new data model.

Related Topic
Specify Data Connection
Description
Select the database connection through which your application accesses the database.

 Properties
You can choose either a new connection or select an existing connection from the drop-down list.

Related Topic
New Database Connection
Description
Create a new connection to the database from which you retrieve information.

 Properties
Field
Value
Example
Driver
Database driver type.
ODBC
Data Sources
Name of the data source.
Employee Database
Database Name
Name of the database from which you retrieve information.

User name
User ID required by the data source.

Password
User password required by the data source.

Related Topic
Specify Input Bindings
Description
Specify the bindings between the parameters in the Source column and the query parameters in the Query Parameters column.

Properties
Field
Value
Example
Query Parameter
Query parameters to bind to the parameters.
SearchEMPID
Source Type
Type of query.
VALIN_BINDING
Source
Name of the source of the parameters.
WhereClause:Report
Insert Row
Add a row.

Delete Row
Remove selected row.

Related Topic
Select DataSet Fields
Description
Select the fields to display for the data set.

 Properties
Field
Value
Example
Table
Table from which you choose fields to display.
Customer
Fields
Field(s) to display.
acctnum, lname
>
Move selected field to Fields to Display.

>>
Move all fields to Fields to Display.

<<
Remove all fields from Fields to Display.

<
Remove selected field from Fields to Display.

Fields to Display
Fields are displayed on the page.
Customer.acctnum
Customer.lname

Related Topic
Select Sort Fields
Description
Specify the order in which retrieved data is organized.

 Properties
Field
Value
Example
Table
Table from which you choose fields to sort by.
Customer
Fields
One or more fields to sort by.
acctnum, lname
>
Move selected field(s) to the Sorted Fields column.

<
Remove selected fields from the Sorted Fields column.

<<
Remove all fields from the Sorted Fields column.

Sorted Fields
Fields by which to sort.
Customer.acctnum
Customer.lname

Related Topic
Finish
Description
Click Finish to complete the property editor.


Query Tab
Description
Choose the query file on which to base your result set and select the type of connection (new or existing) to make to the database.

 Related Topic
Type Tab
Description
Click the radio button corresponding to the type of ResultSet you want to create for your output.

Properties
Choose from the following:


Columns Tab
Description
Specify the column names for your RowSet.

 Properties
Enter the column names for your in-memory, user-populated row set.

 

© Copyright 1999 Netscape Communications Corp.