QueryRowSwap()

swaps one row of a query with an other.

Introduced: 6.0.0.17

QueryRowSwap( query=query, source=numeric, destination=numeric );

Returns: Query

Argument Description
query
query, required

query object to swap rows
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"]
    ]);
    swapped = QueryRowSwap(qry,2,3)
    dump(swapped);
    dump(qry);

See also