RowsMove

Description

Clears a range of rows from one DataWindow control (or DataStore) and inserts them in another. Alternatively, RowsMove moves rows from one buffer to another within a single DataWindow control (or DataStore).

Applies to

Syntax

integer dwcontrol.RowsMove ( long startrow, long endrow, 
	DWBuffer movebuffer, datawindow targetdw, long beforerow,
	DWBuffer targetbuffer )
integer dwcontrol.RowsMove ( long startrow, long endrow,
	DWBuffer movebuffer, datastore targetdw, long beforerow,
	DWBuffer targetbuffer )
integer dwcontrol.RowsMove ( long startrow, long endrow, 
	DWBuffer movebuffer, datawindowchild targetdw, 
	long beforerow, DWBuffer targetbuffer )

number dwcontrol.RowsMove (number startrow, number endrow,
	number movebuffer, datawindow targetdw, number beforerow,
	number targetbuffer )
number dwcontrol.RowsMove (number startrow, number endrow,
	number movebuffer, datawindowchild targetdw, 
	number beforerow, number targetbuffer )

Returns

Returns 1 if it succeeds and –1 if an error occurs.

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

Usage

When you use RowsMove, the rows have the status NewModified! in the target DataWindow.

If you move rows between buffers in a single DataWindow control or DataStore, PowerBuilder retains knowledge of where the rows came from, and their status is changed accordingly. For example, if you move unmodified rows from the primary buffer to the delete buffer, they are marked for deletion. If you move the rows back to the primary buffer, their status returns to NotModified!. Note, however, that if you move rows from one DataWindow control (or DataStore) to another and back again, the rows’ status is NewModified! because they came from a different DataWindow.

The RowsMove method triggers the RowFocusChanging and RowFocusChanged events only when the row number of the current row is changed. The current row is simply a number that indicates which row is the current row. A change in the content of the row does not trigger the events if the number of the current row remains the same.

Suppose you have a DataWindow with two rows. If the current row is row 1 and RowsMove moves row 1, row 2 becomes the current row, but its row number also changes from 2 to 1. The events are not fired because the current row number is still row 1. If the current row is row 2 and RowsMove moves row 1, the events are fired because the current row number has changed from row 2 to row 1.

When you use RowsMove, data is not automatically retrieved for drop-down DataWindows in the target DataWindow, as it is when you call InsertRow. You must explicitly call Retrieve for child DataWindows in the target.

When you use RowsCopy or RowsMove to populate another DataWindow, the copied data is not automatically processed by filters or sort criteria in effect on the target DataWindow. You might be required to call the Filter, GroupCalc, or Sort methods to properly process the data.

Uses for RowsMove include:

• Moving several rows from the primary buffer to the delete buffer, instead of deleting them one at a time

• Moving rows from the delete buffer to the primary buffer, to implement an Undo capability in your application

Examples

Example 1

This statement moves all the rows starting with the first row in the delete buffer for dw_1 to the primary buffer for dw_1, thereby undeleting these rows:

dw_1.RowsMove(1, dw_1.DeletedCount(), Delete!, &

		dw_1, 1, Primary!)

See also