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, PSWebDataWindowClass, server component
Web ActiveX	DataWindow control, DataWindowChild object

Syntax

PowerBuilder

integer dwcontrol.SetRow ( long row )

Web DataWindow client control, PSWebDataWindowClass, 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:

ItemChanged
ItemError
ItemFocusChanged
RowFocusChanged

Avoiding 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)