# Updating a table

**URL:** <https://forum.inductiveautomation.com/t/updating-a-table/62004>\
**Category:** Ignition\
**Tags:** ignition81\
**Created:** [July 18, 2022, 1:45pm UTC](https://forum.inductiveautomation.com/t/updating-a-table/62004 "2022-07-18T13:45:41Z")\
**Posts on this page:** 1\
**Showing post:** 10

<div class="post-metadata">

**Author:** ![lrose](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/lrose/32/62724_2.png) [@lrose](https://forum.inductiveautomation.com/u/lrose)\
**Post date:** [July 18, 2022, 3:07pm UTC](https://forum.inductiveautomation.com/t/updating-a-table/62004/10 "2022-07-18T15:07:07Z")

</div>

Perspective scripts can use the projects default database connection, assuming that one has been provided. See this thread for confirmation of that.

> [@Perspective Workstation architecture question](https://forum.inductiveautomation.com/t/perspective-workstation-architecture-question/59480/25):
>
> Perspective is running inside the context of a particular project (by definition), so on the backend, we pass the project’s default database in to the running script’s context automatically. The individual scripting function implementations “know” to look for this context and extract it, so both things are true: All Perspective scripts run on the gateway Perspective scripts can assume the default database. See [this thread](https://forum.inductiveautomation.com/t/bug-5802-async-tag-event-script-loses-reference-paths/57768) if you’re interested in how that mechanism actually works.

However, I don't like to assume that the system will know the correct connection, (because multiple connections, multiple people working on the same project, etc...). So I always provide the db connection because then it will always work as expected (assuming the query and params are correct)

---

_[View the full topic](https://forum.inductiveautomation.com/t/updating-a-table/62004)._
