Chapter 2: DataWindow Expression Functions

IsRowNew

Description

Reports whether the row has been newly inserted.

Syntax

IsRowNew ( )

Returns

Boolean. Returns TRUE if the row is new and FALSE if it was retrieved from the database.

Usage

In a DataWindow object, when you call IsRowNew in bands other than the detail band, it reports on a row in the detail band. See GetRow for a table specifying which row is associated with each band for reporting purposes.

Examples

Example 1

This expression defined in the Properties view for the Protect property of a column prevents the user from modifying the column unless the row has been newly inserted:

If(IsRowNew(), 0, 1)