# QueryInsertAt

Inserts a query data into another query at a specific position

## Method Signature

```
QueryInsertAt(query=[query], value=[query], position=[numeric])
```

### Arguments

| Argument   | Type      | Required | Description                                   | Default |
| ---------- | --------- | -------- | --------------------------------------------- | ------- |
| `query`    | `query`   | `true`   | The source query to insert to                 |         |
| `value`    | `query`   | `true`   | The query that will be inserted               |         |
| `position` | `numeric` | `true`   | The position where the query will be inserted |         |

## Examples

### Example1

This is Example1

[Run Example](https://try.boxlang.io/?code=eJyVjzELwjAQhefkVxyZKmTRuomD4qKDoAgdSodoTxtoG3tNLPn3Nqmgq8sN3wfvvevIwxo6h%2BSPOCQgyAy6lK1qUEgQurX4QJIvRbdK0Yhy4CznjM3leMRBecFZISe2iGxrrj8sjexSoSkN4Y9YRpHputaqCZwXMFtxcnfXj5NOf0z6BE715xDwzYuv7dseyW5sAh15CbFDQhp8RtrizjXP6AJ5Ay0pSK4%3D)

```java
qry = queryNew( "rowid,name", "integer,varchar", [ 
	[
		1,
		"Jay"
	],
	[
		2,
		"Bob"
	],
	[
		3,
		"Theodore"
	],
	[
		4,
		"William"
	]
] );
rufus = QueryNew( "rowid,name", "integer,varchar", [
	[
		42,
		"Rufus"
	]
] );
queryInsertAt( qry, rufus, 3 );
WriteDump( qry );

```

### Member function version.

Using the member function.

[Run Example](https://try.boxlang.io/?code=eJyVjj0LwjAURefmVzwyVQiC1k0cFBcdBEXoUDpE%2B7SBftjXxJJ%2Fb5IKdnV5w7mX825HFjbQGSR7wiEGTu2gCtHIGrkArhqNTyTxlnQvJTmUAYsyFkUL4Q4%2FSstZlIuRLQPbtbcJSwK7ltgWLeEkWIUgVVWlZO05y2G2ZmQepneTzn9M%2BgrH9xcv%2BPk6svND0yPprY4h2AUkPklJadyb%2BhWDK3nyAWpCRlo%3D)

```java
qry = queryNew( "rowid,name", "integer,varchar", [ 
	[
		1,
		"Jay"
	],
	[
		2,
		"Bob"
	],
	[
		3,
		"Theodore"
	],
	[
		4,
		"William"
	]
] );
rufus = QueryNew( "rowid,name", "integer,varchar", [
	[
		42,
		"Rufus"
	]
] );
qry.InsertAt( rufus, 3 );
WriteDump( qry );

```

### Additional Examples

[Run Example](https://try.boxlang.io/?code=eJyV0LEKwjAQgOG5eYojU4UMtoqg4lBx0UGR4lQcilzbDE3ba2Lp25sSLQUXXcLxcfwcaagPYAeNQerP2PnAVVqigDRHLoA%2FU3oUKQmQSmOOZC0B5iXM83hsWsmFncI58%2B7irTdqHS4nGJdSF46DCZ%2BqQjldWWV3mG1ZQ33450GfGip3T7Aeax1JjReja6NtaY9ZRQjXoX1ULZKGDR%2FXDqasfWiGD7E0WYq0YzG8oYDFdznKNNJv4RfXX2Uy)

```java
qry1 = queryNew( "name, age", "varchar, integer", [ 
	[
		"Susi",
		20
	],
	[
		"Urs",
		24
	],
	[
		"Smith",
		21
	],
	[
		"John",
		26
	]
] );
qry2 = queryNew( "name, age", "varchar, integer", [
	[
		"Jeni",
		19
	]
] );
writeOutput( "Before QueryInsert :" );
writeDump( qry1 );
QueryInsertAt( qry1, qry2, 3 );
writeOutput( "After QueryInsert :" );
writeDump( qry1 );

```

## 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)
* [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)
* [QueryRowSwap](https://boxlang.ortusbooks.com/boxlang-language/reference/built-in-functions/query/queryrowswap)
* [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)