# QueryRowSwap

In a query object, swap the record in the sourceRow with the record from the destinationRow.

## Method Signature

```
QueryRowSwap(query=[query], source=[numeric], destination=[numeric])
```

### Arguments

| Argument      | Type      | Required | Description                  | Default |
| ------------- | --------- | -------- | ---------------------------- | ------- |
| `query`       | `query`   | `true`   | The query to swap a row with |         |
| `source`      | `numeric` | `true`   | The row to swap from         |         |
| `destination` | `numeric` | `true`   | The row to swap to           |         |

## Examples

### Example1

This is Example1

[Run Example](https://try.boxlang.io/?code=eJxNzjELwjAQBeA5%2BRVHpgq3VLuJizh1cFDBoXSI9rCBtjFna8i%2FN00Ruhy8773hHAc4gJuIw5l8BoqtNw0OuieFoMww0osYv5qfreZIFUhRSSFyjEcd7UNJUeNi22S3lmxjmVbFLhWlDisrkt1N1xndzy5r2Ozlx%2Bt3%2Fn%2FpYv015gwcB4QcoZgnns1Ip6mPvqyj%2FQAo9TLP)

```java
qry = queryNew( "rowid,name", "integer,varchar", [ 
	[
		1,
		"Bob"
	],
	[
		2,
		"Theodore"
	],
	[
		3,
		"Jay"
	],
	[
		4,
		"William"
	]
] );
swap1 = queryRowSwap( qry, 1, 4 );
writeDump( swap1 );

```

### Member function version.

Using the member function.

[Run Example](https://try.boxlang.io/?code=eJxNzjEPgjAQBeC5%2FRWXTphcTEA242KYHFw0cSAMVS7ShFI5wab%2F3hYWlkvue294Iwc4wTgThyv5DBQ7b1octCWFoMww0ZsYf5pfneZINUhRSyFyjEed3VNJ0eBqxWL3jlzrmDbBYQkuOmysXOxh%2Bt5om1w2sDvKr9efIk3isI9bbvHNIEcoU%2BjZTFTNNtLai%2FYH6yUwnQ%3D%3D)

```java
qry = queryNew( "rowid,name", "integer,varchar", [ 
	[
		1,
		"Bob"
	],
	[
		2,
		"Theodore"
	],
	[
		3,
		"Jay"
	],
	[
		4,
		"William"
	]
] );
swap2 = qry.rowSwap( 1, 4 );
writeDump( swap2 );

```

### Additional Examples

[Run Example](https://try.boxlang.io/?code=eJxNzbEKwkAMBuD58hThpgpZbEfxFQR1LB1iL6hDay%2B1Hvf25iqKS%2Fjz8cMfNeMe4yKaD5Iq9PdAIw%2FiyeL4lKsovVj7G6tRi%2BBacG5Ldjx7cB19pF7l8ifNKn0R6HCzgznxNEmwuWOZOz3S2aTCqJmwJmxKKSyD0bf6A%2BuU5w0PzSxE)

```java
qry = queryNew( "id,name", "integer,varchar", [ 
	[
		1,
		"a"
	],
	[
		2,
		"b"
	],
	[
		3,
		"c"
	]
] );
swapped = QueryRowSwap( qry, 2, 3 );
dump( swapped );
dump( qry );

```

## Related

* [QueryAddColumn](https://boxlang.ortusbooks.com/boxlang-language/reference/built-in-functions/query/queryaddcolumn)
* [QueryAddRow](https://boxlang.ortusbooks.com/boxlang-language/reference/built-in-functions/query/queryaddrow)
* [QueryAppend](https://boxlang.ortusbooks.com/boxlang-language/reference/built-in-functions/query/queryappend)
* [QueryClear](https://boxlang.ortusbooks.com/boxlang-language/reference/built-in-functions/query/queryclear)
* [QueryColumnArray](https://boxlang.ortusbooks.com/boxlang-language/reference/built-in-functions/query/querycolumnarray)
* [QueryColumnCount](https://boxlang.ortusbooks.com/boxlang-language/reference/built-in-functions/query/querycolumncount)
* [QueryColumnData](https://boxlang.ortusbooks.com/boxlang-language/reference/built-in-functions/query/querycolumndata)
* [QueryColumnExists](https://boxlang.ortusbooks.com/boxlang-language/reference/built-in-functions/query/querycolumnexists)
* [QueryColumnList](https://boxlang.ortusbooks.com/boxlang-language/reference/built-in-functions/query/querycolumnlist)
* [QueryCurrentRow](https://boxlang.ortusbooks.com/boxlang-language/reference/built-in-functions/query/querycurrentrow)
* [QueryDeleteColumn](https://boxlang.ortusbooks.com/boxlang-language/reference/built-in-functions/query/querydeletecolumn)
* [QueryDeleteRow](https://boxlang.ortusbooks.com/boxlang-language/reference/built-in-functions/query/querydeleterow)
* [QueryEach](https://boxlang.ortusbooks.com/boxlang-language/reference/built-in-functions/query/queryeach)
* [QueryEvery](https://boxlang.ortusbooks.com/boxlang-language/reference/built-in-functions/query/queryevery)
* [QueryFilter](https://boxlang.ortusbooks.com/boxlang-language/reference/built-in-functions/query/queryfilter)
* [QueryGetCell](https://boxlang.ortusbooks.com/boxlang-language/reference/built-in-functions/query/querygetcell)
* [QueryGetResult](https://boxlang.ortusbooks.com/boxlang-language/reference/built-in-functions/query/querygetresult)
* [QueryInsertAt](https://boxlang.ortusbooks.com/boxlang-language/reference/built-in-functions/query/queryinsertat)
* [QueryKeyExists](https://boxlang.ortusbooks.com/boxlang-language/reference/built-in-functions/query/querykeyexists)
* [QueryMap](https://boxlang.ortusbooks.com/boxlang-language/reference/built-in-functions/query/querymap)
* [QueryNew](https://boxlang.ortusbooks.com/boxlang-language/reference/built-in-functions/query/querynew)
* [QueryNone](https://boxlang.ortusbooks.com/boxlang-language/reference/built-in-functions/query/querynone)
* [QueryPrepend](https://boxlang.ortusbooks.com/boxlang-language/reference/built-in-functions/query/queryprepend)
* [QueryRecordCount](https://boxlang.ortusbooks.com/boxlang-language/reference/built-in-functions/query/queryrecordcount)
* [QueryRecordCount](https://boxlang.ortusbooks.com/boxlang-language/reference/built-in-functions/query/queryrecordcount)
* [QueryReduce](https://boxlang.ortusbooks.com/boxlang-language/reference/built-in-functions/query/queryreduce)
* [QueryRegisterFunction](https://boxlang.ortusbooks.com/boxlang-language/reference/built-in-functions/query/queryregisterfunction)
* [QueryReverse](https://boxlang.ortusbooks.com/boxlang-language/reference/built-in-functions/query/queryreverse)
* [QueryRowData](https://boxlang.ortusbooks.com/boxlang-language/reference/built-in-functions/query/queryrowdata)
* [QuerySetCell](https://boxlang.ortusbooks.com/boxlang-language/reference/built-in-functions/query/querysetcell)
* [QuerySetRow](https://boxlang.ortusbooks.com/boxlang-language/reference/built-in-functions/query/querysetrow)
* [QuerySlice](https://boxlang.ortusbooks.com/boxlang-language/reference/built-in-functions/query/queryslice)
* [QuerySome](https://boxlang.ortusbooks.com/boxlang-language/reference/built-in-functions/query/querysome)
* [QuerySort](https://boxlang.ortusbooks.com/boxlang-language/reference/built-in-functions/query/querysort)