Updating a table

[lrose]

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

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 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)