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