KeyClause

Description

An expression to be used as the key clause when retrieving the blob.

Applies to

TableBlob controls

Syntax

PowerBuilder dot notation:

dw_control.Object.tblobname.KeyClause

Describe and Modify argument:

"tblobname.KeyClause { = ' keyclause ' }"

Parameter	Description
tblobname	The name of the TableBlob for which you want to specify a key clause.
keyclause	(exp) A string that will be built into a key clause using the substitutions provided. The key clause can be any valid WHERE clause. Keyclause can be a quoted DataWindow expression.

Usage

In the painter

Select the control and set the value in the Properties view, Definition tab, Key Clause option.

Examples

Example 1

With the following setting, the value of key_col will be put in col2 when PowerBuilder constructs the WHERE clause for the SELECTBLOB statement:

dw1.Modify(blob_1.KeyClause='Key_col = :col2'")