Invert  KeyClause

Chapter 3: DataWindow Object Properties

Key

Description

Whether the column is part of the database table’s primary key.

Applies to

Column controls

Syntax

PocketBuilder dot notation:

dw_control.Object.columnname.Key

Describe and Modify argument:

"columnname.Key { = value }"

Parameter

Description

columnname

The column for which you want to get or set primary key status.

value

Whether the column is part of the primary key. Values are:

  • Yes — The column is part of the primary key.

  • No — The column is not part of the key.

Usage


In the painter

Set the value using the Rows menu, Update Properties.

Examples

Example 1

string setting

setting = dw_1.Object.empid.Key

Example 2

dw_1.Object.empid.Key = "Yes"

Example 3

setting = dw_1.Describe("empid.Key")

Example 4

dw_1.Modify("empid.Key=Yes")





Copyright © 2004. Sybase Inc. All rights reserved. KeyClause

View this book as PDF