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 window, Definition category.

Examples

Example 1

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:

[Visual Basic]
dw1.Modify(blob_1.KeyClause='Key_col = :col2'")