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