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