Purpose:

Used to display data.

Overview:

A DataView requires a stored procedure that returns a value. The value returned by the stored procedure is what the DataView will display.

If the stored procedure contains parameters, these become the DataView Parameters.

Usage:

A DataView is used to view data. If the DataView contains DataView Parameters, these can be mapped to other parameters or defaulted.

Configuration:

Create New DataView

Name:

The name by which the DataView will be known within FrameworX.

(Hint) Use meaningful names as this will help identify the DataView when used elsewhere in FrameworX.

Description:

(Optional) Brief description of the DataView .

Database Connection:

The Database Connection containing the stored procedure to be used for the DataView .

Stored Procedure:

The name of the stored procedure to be used for the DataView .

The last select in the stored procedure becomes the result of the DataView .

DataView Stored Procedure

Cache Lifetime:*

If caching is enabled, the lifetime (in seconds) determines how long the DataView result is held in cache. A value of 0 causes the DataView result to be held in the cache permanently for the DataView Parameter combination.

 

Show Parameters:

Selecting show parameters will make the DataView  parameters visible.

In Grid Edit:

Allows for changed to be made in grid without needing to launch the update action.

See also:

DataView Parameters

DataView Columns

How To:

How to: Configuring and using a DataView