KeyClause DataWindow object property

Description

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

Controls

TableBlob controls

Syntax

PowerBuilder dot notation:

<span>dw_control</span>.Object.<span>tblobname</span>.KeyClause

1	<span>dw_control</span>.Object.<span>tblobname</span>.KeyClause

Describe and Modify argument:

"<span>tblobname</span>.KeyClause { = '<span> keyclause </span>' }"

1	"<span>tblobname</span>.KeyClause { = '<span> keyclause </span>' }"

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 the DataWindow server constructs the WHERE clause
for the SELECTBLOB statement:

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

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

Document get from Powerbuilder help

Thank you for watching.

Powerbuilder Documentation 12.6

August 14, 2023

Was this article helpful?

Connection Information

KeyClause – PB Docs 126