# system.db.runPrepQuery - Argument Syntax

**URL:** <https://forum.inductiveautomation.com/t/system-db-runprepquery-argument-syntax/59408>\
**Category:** Ignition\
**Tags:** vision\
**Created:** [May 10, 2022, 2:54pm UTC](https://forum.inductiveautomation.com/t/system-db-runprepquery-argument-syntax/59408 "2022-05-10T14:54:53Z")\
**Posts on this page:** 1\
**Showing post:** 6

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [August 3, 2023, 3:19pm UTC](https://forum.inductiveautomation.com/t/system-db-runprepquery-argument-syntax/59408/6 "2023-08-03T15:19:57Z")

</div>

Follow up:

> [@Read/Write and Clear from an Array Tag (integer array)](https://forum.inductiveautomation.com/t/read-write-and-clear-from-an-array-tag-integer-array/74199/5):
>
> Does it work if you convert the list into a jarray first? v = [0,1,2,3] import jarray from java.lang import Integer v\_arr = jarray.array(v, Integer) To be honest I'm not even sure if array columns are supported or not, but see if this gets you to an error somewhere further.

---

_[View the full topic](https://forum.inductiveautomation.com/t/system-db-runprepquery-argument-syntax/59408)._