KeyClause

Description

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

Applies to

TableBlob controls

Syntax

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'")