SetRow

Description

Sets the current row in a DataWindow control or DataStore.

Applies to

DataWindow type

Method applies to

PowerBuilder

DataWindow control, DataWindowChild object, DataStore object

Web

Client control, server component

Web ActiveX

DataWindow control, DataWindowChild object

Syntax

PowerBuilder

integer dwcontrol.SetRow ( long row )

Web DataWindow client control and Web ActiveX

number dwcontrol.SetRow ( number row ) 

Web DataWindow server component

short dwcontrol.SetRow ( long row )

Argument

Description

dwcontrol

A reference to a DataWindow control, DataStore, or child DataWindow in which you want to set the current row

row

The row you want to make current

Returns

Returns 1 if it succeeds and –1 if an error occurs. If row is less than 1 or greater than the number of rows, SetRow fails.

If any argument’s value is null, in PowerBuilder and JavaScript the method returns null.

Usage

SetRow moves the cursor to the current row but does not scroll the DataWindow control or DataStore.


Events

SetRow can trigger these events:

NoteAvoiding infinite loops Never call SetRow in the ItemChanged event or any of the other events listed above. Because SetRow can trigger these events, such a recursive call can cause a stack fault.

Examples

Example 1

This statement sets the current row in dw_employee to 15:

dw_employee.SetRow(15)

Example 2

This example unhighlights all highlighted rows, if any. It then sets the current row to 15 and highlights it. If row 15 is not visible, you can use ScrollToRow instead of SetRow:

dw_employee.SelectRow(0, false)

dw_employee.SetRow(15)

dw_employee.SelectRow(15, true)

See also