query.rowSwap()
swaps one row of a query with an other.
Introduced: 6.0.0.17
query.rowSwap( source=numeric, destination=numeric )
Returns: Query
Argument | Description |
---|---|
source
numeric,
required
|
The row to swap. Alias: sourceRow, src |
destination
numeric,
required
|
The row to be swapped with. Alias: destinationRow, dest, target |
Examples
qry = queryNew("id,name", "integer,varchar",
[
[1, "a"],
[2, "b"],
[3, "c"]
]);
dump(qry);
swapped = qry.rowSwap(2,3)
dump(swapped);