# Dynamic Dataset

**URL:** <https://forum.inductiveautomation.com/t/dynamic-dataset/33207>\
**Category:** Ignition\
**Created:** [March 18, 2020, 2:08pm UTC](https://forum.inductiveautomation.com/t/dynamic-dataset/33207 "2020-03-18T14:08:11Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![dcamp1](https://avatars.discourse-cdn.com/v4/letter/d/dc4da7/32.png) [@dcamp1](https://forum.inductiveautomation.com/u/dcamp1)\
**Post date:** [March 18, 2020, 2:08pm UTC](https://forum.inductiveautomation.com/t/dynamic-dataset/33207/1 "2020-03-18T14:08:11Z")

</div>

This Query works:  
system.db.runQuery(select itemdesc from locinv where locid = 1)

This does not work:  
InvID = event.source.selectRow + 1  
system.db.runQuery(select itemdesc from locinv where locid = InvID)

Please help

---

<div class="post-metadata">

**Author:** ![KathyApplebaum](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kathyapplebaum/32/7261_2.png) [@KathyApplebaum](https://forum.inductiveautomation.com/u/KathyApplebaum)\
**Post date:** [March 18, 2020, 2:18pm UTC](https://forum.inductiveautomation.com/t/dynamic-dataset/33207/2 "2020-03-18T14:18:26Z")

</div>

You’re going to need to construct the string that’s the argument for system.db.runQuery, or switch to system.db.runPrepQuery (preferred)

```auto
InvID = event.source.selectRow + 1
queryString = "select itemdesc from locinv where locid = " + InvID
system.db.runQuery(queryString)

```

or

```auto
InvID = event.source.selectRow + 1
queryString = "select itemdesc from locinv where locid = ?" 
system.db.runPrepQuery(queryString, [InvID])

```

---

<div class="post-metadata">

**Author:** ![dcamp1](https://avatars.discourse-cdn.com/v4/letter/d/dc4da7/32.png) [@dcamp1](https://forum.inductiveautomation.com/u/dcamp1)\
**Post date:** [March 18, 2020, 2:34pm UTC](https://forum.inductiveautomation.com/t/dynamic-dataset/33207/3 "2020-03-18T14:34:17Z")

</div>

Thank you so very much, it is now working as I expect.