# Ignition **URL:** https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=1324 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 1325 --- ## [SQL query for time](https://forum.inductiveautomation.com/t/sql-query-for-time/21823)
**Author:** [@jhuff](https://forum.inductiveautomation.com/u/jhuff)\ **Replies:** 1\ **Last updated:** [January 11, 2019, 3:12pm UTC](https://forum.inductiveautomation.com/t/sql-query-for-time/21823 "2019-01-11T15:12:11Z")
When running a query from SQL database, a DateTime field in the database has seconds recorded down to three decimals, but the returned results are only down to the second. Anyone else run into this issue? Example: 201… --- ## [Tag Even Change Based on Time of Running Timer Tag](https://forum.inductiveautomation.com/t/tag-even-change-based-on-time-of-running-timer-tag/19999)
**Author:** [@Tim.Canan](https://forum.inductiveautomation.com/u/Tim.Canan)\ **Replies:** 4\ **Last updated:** [January 11, 2019, 3:04pm UTC](https://forum.inductiveautomation.com/t/tag-even-change-based-on-time-of-running-timer-tag/19999 "2019-01-11T15:04:58Z")
Can someone help me figure out how to get the below script working? It works for the first specified execution and tag path (WC216), but doesn't work for the next two tag paths. Is this because the time is no longer what… --- ## [Getting error trying to install client](https://forum.inductiveautomation.com/t/getting-error-trying-to-install-client/21820)
**Author:** [@Schwartzds](https://forum.inductiveautomation.com/u/Schwartzds)\ **Replies:** 0\ **Last updated:** [January 11, 2019, 2:41pm UTC](https://forum.inductiveautomation.com/t/getting-error-trying-to-install-client/21820 "2019-01-11T14:41:41Z")
When trying to install client getting a weird error. %1 is not a valid win32 program. Then asks for debugging. Any suggestions? --- ## [Rectangle size question](https://forum.inductiveautomation.com/t/rectangle-size-question/21814)
**Author:** [@Henk](https://forum.inductiveautomation.com/u/Henk)\ **Replies:** 1\ **Last updated:** [January 11, 2019, 1:15pm UTC](https://forum.inductiveautomation.com/t/rectangle-size-question/21814 "2019-01-11T13:15:00Z")
When I place a square (size 200x200) on position (0,0) on a 200x200 template with a stroke style width of 51 (thick line) then part of the border falls outside the template and is also not visible when the template is us… --- ## [Translation of titled borders](https://forum.inductiveautomation.com/t/translation-of-titled-borders/21813)
**Author:** [@manca](https://forum.inductiveautomation.com/u/manca)\ **Replies:** 0\ **Last updated:** [January 11, 2019, 11:08am UTC](https://forum.inductiveautomation.com/t/translation-of-titled-borders/21813 "2019-01-11T11:08:27Z")
Hi, I’m using Ignition 7.9.10. While working on components that use the titled border feature I’ve noticed that in the designer the translations work flawlessly only when instancing a new component. After testing and s… --- ## [Help! It is posible to work with expressions and indirect tag?](https://forum.inductiveautomation.com/t/help-it-is-posible-to-work-with-expressions-and-indirect-tag/18203)
**Author:** [@bryandavid.1031](https://forum.inductiveautomation.com/u/bryandavid.1031)\ **Replies:** 5\ **Last updated:** [January 11, 2019, 3:27am UTC](https://forum.inductiveautomation.com/t/help-it-is-posible-to-work-with-expressions-and-indirect-tag/18203 "2019-01-11T03:27:17Z")
Hi, I´m developing a project for the first time in Ingnition, so I’m learning it´s use. I watched the video for indirect tag binding, because I want to use similar tags from different instances, so it worked well. But th… --- ## [Removing items in a window through project script?](https://forum.inductiveautomation.com/t/removing-items-in-a-window-through-project-script/19770)
**Author:** [@joe.brodersen](https://forum.inductiveautomation.com/u/joe.brodersen)\ **Replies:** 9\ **Last updated:** [January 10, 2019, 10:38pm UTC](https://forum.inductiveautomation.com/t/removing-items-in-a-window-through-project-script/19770 "2019-01-10T22:38:35Z")
Is there a way to remove an object (e.g. a button) from a project script? I can use the .getWindow and .getRootContainer to access the window's components, but I'm trying to find a component.delete or something to that … --- ## [How import csv tag list file by script](https://forum.inductiveautomation.com/t/how-import-csv-tag-list-file-by-script/21799)
**Author:** [@nader.chinichian](https://forum.inductiveautomation.com/u/nader.chinichian)\ **Replies:** 0\ **Last updated:** [January 10, 2019, 8:36pm UTC](https://forum.inductiveautomation.com/t/how-import-csv-tag-list-file-by-script/21799 "2019-01-10T20:36:33Z")
Hi Is it possible to import csv tag list into ignition by script? I create several tag configuration and want operator dynamically import them in runtime. Thanks. --- ## [Documenting Client Information](https://forum.inductiveautomation.com/t/documenting-client-information/21795)
**Author:** [@dkhayes117](https://forum.inductiveautomation.com/u/dkhayes117)\ **Replies:** 1\ **Last updated:** [January 10, 2019, 8:31pm UTC](https://forum.inductiveautomation.com/t/documenting-client-information/21795 "2019-01-10T20:31:29Z")
I have a project that uses 3 small windows in tabular navi (hopefully setup to work on tablets in portrait position, or on a laptop) and I'm trying to document the information that is created with the project. Basically… --- ## [How can I get MySQL Demo DB back after deleting?](https://forum.inductiveautomation.com/t/how-can-i-get-mysql-demo-db-back-after-deleting/21786)
**Author:** [@barb.meienburg](https://forum.inductiveautomation.com/u/barb.meienburg)\ **Replies:** 3\ **Last updated:** [January 10, 2019, 7:31pm UTC](https://forum.inductiveautomation.com/t/how-can-i-get-mysql-demo-db-back-after-deleting/21786 "2019-01-10T19:31:59Z")
Can someone help me? I let several months go by between training courses. My last class required me to update Ignition as well as MySQL and in that process, I no longer have a MySQL DemoyyyyMMdd.gwbk to restore per the… --- ## [Wrapper.log error that I can't resolve](https://forum.inductiveautomation.com/t/wrapper-log-error-that-i-cant-resolve/21793)
**Author:** [@mbufarini](https://forum.inductiveautomation.com/u/mbufarini)\ **Replies:** 1\ **Last updated:** [January 10, 2019, 6:54pm UTC](https://forum.inductiveautomation.com/t/wrapper-log-error-that-i-cant-resolve/21793 "2019-01-10T18:54:10Z")
About a couple of month ago (perhaps after a modification in some of the 6 project that run in the Gateway) I start to see an event like this in the wrapper.log: INFO | jvm 1 | 2019/01/09 16:22:21 | Syntax error I… --- ## [Updating multiple dataset values](https://forum.inductiveautomation.com/t/updating-multiple-dataset-values/21789)
**Author:** [@francisco.romero](https://forum.inductiveautomation.com/u/francisco.romero)\ **Replies:** 2\ **Last updated:** [January 10, 2019, 6:36pm UTC](https://forum.inductiveautomation.com/t/updating-multiple-dataset-values/21789 "2019-01-10T18:36:21Z")
Hi, I have a script on a numeric label, each time the value changes I do some operations and depending on the result of the operations I update several rows of a table dataset. What I have now is this: if event.propert… --- ## [How to Update/Modify an existing row in a db Table, using a component's actionPerformed Script?](https://forum.inductiveautomation.com/t/how-to-update-modify-an-existing-row-in-a-db-table-using-a-components-actionperformed-script/21779)
**Author:** [@paulm1](https://forum.inductiveautomation.com/u/paulm1)\ **Replies:** 5\ **Last updated:** [January 10, 2019, 3:33pm UTC](https://forum.inductiveautomation.com/t/how-to-update-modify-an-existing-row-in-a-db-table-using-a-components-actionperformed-script/21779 "2019-01-10T15:33:02Z")
https://docs.inductiveautomation.com/display/DOC79/system.db.runPrepUpdate I use the following script within a components actionPerformed script area and it works great for Inserting/adding a new row into an existing d… --- ## [Client Timer Script vs Timer component - Ignition Edge](https://forum.inductiveautomation.com/t/client-timer-script-vs-timer-component-ignition-edge/21776)
**Author:** [@bankeny2](https://forum.inductiveautomation.com/u/bankeny2)\ **Replies:** 4\ **Last updated:** [January 9, 2019, 10:05pm UTC](https://forum.inductiveautomation.com/t/client-timer-script-vs-timer-component-ignition-edge/21776 "2019-01-09T22:05:13Z")
I have a repetitive task that needs to execute every second to repopulate some tables on a screen. In order to prevent bogging down the UI, I would normally execute this on the gateway and write the values to a dataset t… --- ## [Multi-state indicator function?](https://forum.inductiveautomation.com/t/multi-state-indicator-function/21775)
**Author:** [@whumphrey](https://forum.inductiveautomation.com/u/whumphrey)\ **Replies:** 1\ **Last updated:** [January 9, 2019, 8:43pm UTC](https://forum.inductiveautomation.com/t/multi-state-indicator-function/21775 "2019-01-09T20:43:27Z")
Hi. New to ignition and doing some testing. I want to display an enumerated list of text strings based on an integer tag using a multi-state indicator. I can make it work perfectly selecting Driving Property:State and… --- ## [Dynamic pens on chart](https://forum.inductiveautomation.com/t/dynamic-pens-on-chart/21774)
**Author:** [@WChester](https://forum.inductiveautomation.com/u/WChester)\ **Replies:** 1\ **Last updated:** [January 9, 2019, 8:38pm UTC](https://forum.inductiveautomation.com/t/dynamic-pens-on-chart/21774 "2019-01-09T20:38:09Z")
I have a data set where I would like to use an xy chart for some data that is in a format similar to this In the chart I’d like to have a separate pen for each Part SN(the number of part SN’s are not fixed) and plot … --- ## [Moving dashed line around table](https://forum.inductiveautomation.com/t/moving-dashed-line-around-table/21768)
**Author:** [@bankeny2](https://forum.inductiveautomation.com/u/bankeny2)\ **Replies:** 3\ **Last updated:** [January 9, 2019, 8:26pm UTC](https://forum.inductiveautomation.com/t/moving-dashed-line-around-table/21768 "2019-01-09T20:26:53Z")
I have several tables on one of my screens that exhibit moving dashed lines along the table borders. It occurs in the staging and published versions and is very distracting. I can’t seem to find the setting to disable i… --- ## [Components out of place](https://forum.inductiveautomation.com/t/components-out-of-place/21771)
**Author:** [@Schwartzds](https://forum.inductiveautomation.com/u/Schwartzds)\ **Replies:** 3\ **Last updated:** [January 9, 2019, 7:54pm UTC](https://forum.inductiveautomation.com/t/components-out-of-place/21771 "2019-01-09T19:54:52Z")
Ok on one of my screens images are one way in designer and different when published. This is only happening on one side of the screen. I have a label in place under an object and then when published the label is not unde… --- ## [Time Series Chart Set Date Interval?](https://forum.inductiveautomation.com/t/time-series-chart-set-date-interval/21764)
**Author:** [@uTewell](https://forum.inductiveautomation.com/u/uTewell)\ **Replies:** 2\ **Last updated:** [January 9, 2019, 7:17pm UTC](https://forum.inductiveautomation.com/t/time-series-chart-set-date-interval/21764 "2019-01-09T19:17:28Z")
I am using a time series chart in a report I am designing. I am having an issuing trying to figure out how to use the jfreechart scripting. If the user inputs a small enough date range then the time axis will display … --- ## [Using system.opc.readValue() on a remote gateway](https://forum.inductiveautomation.com/t/using-system-opc-readvalue-on-a-remote-gateway/21748)
**Author:** [@ibrandstetter](https://forum.inductiveautomation.com/u/ibrandstetter)\ **Replies:** 5\ **Last updated:** [January 9, 2019, 7:08pm UTC](https://forum.inductiveautomation.com/t/using-system-opc-readvalue-on-a-remote-gateway/21748 "2019-01-09T19:08:08Z")
I have a runtime/tag architecture, where the vision windows are hosted on Server1, and the tags are hosted on Server2. Server1 is connected to Server2 through the Gateway network. I would like to have a script execut… --- ## [Restoring Projects](https://forum.inductiveautomation.com/t/restoring-projects/21747)
**Author:** [@carolineuchoa.estuda](https://forum.inductiveautomation.com/u/carolineuchoa.estuda)\ **Replies:** 7\ **Last updated:** [January 9, 2019, 6:59pm UTC](https://forum.inductiveautomation.com/t/restoring-projects/21747 "2019-01-09T18:59:57Z")
Please, help! Someone apparently uninstalled Igntion Designer from my computer and now there’s no projects avaiable on my web browser. I didnt export any of the projects and now I’m worried I’m gonna lose all my work. … --- ## [Startup window after publishing changes](https://forum.inductiveautomation.com/t/startup-window-after-publishing-changes/21766)
**Author:** [@bpreston](https://forum.inductiveautomation.com/u/bpreston)\ **Replies:** 7\ **Last updated:** [January 9, 2019, 5:07pm UTC](https://forum.inductiveautomation.com/t/startup-window-after-publishing-changes/21766 "2019-01-09T17:07:03Z")
When I publish changes right now the main screen is staying on the page it was, prior to the publish, after it reloads. I'd like it to return to the window that is selected for open on startup. I've tried a few differe… --- ## [Troubleshooting error 'Error executing jsonGet(): null'](https://forum.inductiveautomation.com/t/troubleshooting-error-error-executing-jsonget-null/21769)
**Author:** [@mrogers](https://forum.inductiveautomation.com/u/mrogers)\ **Replies:** 1\ **Last updated:** [January 9, 2019, 4:45pm UTC](https://forum.inductiveautomation.com/t/troubleshooting-error-error-executing-jsonget-null/21769 "2019-01-09T16:45:10Z")
We've been getting this log error (technically debug status, logger com.inductiveautomation.ignition.common.expressions.JsonGet). The text quoted above is the entire message, and there is the text 'java.lang.NullPointerE… --- ## [Assigning Dynamic Tag Paths](https://forum.inductiveautomation.com/t/assigning-dynamic-tag-paths/21762)
**Author:** [@brendan.curran](https://forum.inductiveautomation.com/u/brendan.curran)\ **Replies:** 3\ **Last updated:** [January 9, 2019, 2:48pm UTC](https://forum.inductiveautomation.com/t/assigning-dynamic-tag-paths/21762 "2019-01-09T14:48:39Z")
Is there a way to assign an OPC path to a tag via scripting. I currently have pointers that will direct to a location in the PLC. However, importing all these OPC tags is not a good option (would have to import over 200k… --- ## [Error reading some addresses disappears if I rename the device](https://forum.inductiveautomation.com/t/error-reading-some-addresses-disappears-if-i-rename-the-device/21763)
**Author:** [@rdelasheras](https://forum.inductiveautomation.com/u/rdelasheras)\ **Replies:** 2\ **Last updated:** [January 9, 2019, 2:30pm UTC](https://forum.inductiveautomation.com/t/error-reading-some-addresses-disappears-if-i-rename-the-device/21763 "2019-01-09T14:30:10Z")
Hello, One of my TCP Modbus devices named AGR\_1 has tags in addresses from 124 to 137 in WORDS memory. Some days ago, tags attached to addresses 126, 127, .. 137 has quality Unknown. In the QuickClient of the gateway… --- ## [Is it possible to have my gateway run a system.db.refresh?](https://forum.inductiveautomation.com/t/is-it-possible-to-have-my-gateway-run-a-system-db-refresh/21746)
**Author:** [@bkarabinchak.psi](https://forum.inductiveautomation.com/u/bkarabinchak.psi)\ **Replies:** 3\ **Last updated:** [January 9, 2019, 2:06pm UTC](https://forum.inductiveautomation.com/t/is-it-possible-to-have-my-gateway-run-a-system-db-refresh/21746 "2019-01-09T14:06:11Z")
Here's the situation. I have a long query (you may remember my post from last week, well I was unable to optimize despite all attempts and I need a solution even if temporary) that takes a long time to load, which reall… --- ## [Get Ignition client window size](https://forum.inductiveautomation.com/t/get-ignition-client-window-size/21524)
**Author:** [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\ **Replies:** 5\ **Last updated:** [January 9, 2019, 1:34am UTC](https://forum.inductiveautomation.com/t/get-ignition-client-window-size/21524 "2019-01-09T01:34:49Z")
I'm looking to get the full size of the client window (i.e. the desktop size), not just the individual windows that make up the client display. E.g. I want to get the combined size of all docked window(s) and the floatin… --- ## [Parameters in applet project](https://forum.inductiveautomation.com/t/parameters-in-applet-project/8262)
**Author:** [@NestorRodriguez](https://forum.inductiveautomation.com/u/NestorRodriguez)\ **Replies:** 1\ **Last updated:** [January 9, 2019, 12:10am UTC](https://forum.inductiveautomation.com/t/parameters-in-applet-project/8262 "2019-01-09T00:10:06Z")
I'm trying to pass parameters a project in applet mode, I'm using the code of a previuos posts: from javax.swing import JApplet from javax.swing import SwingUtilities applet = SwingUtilities.getAncestorOfClass(JApplet,… --- ## [HT503 Voice Alarming but no DTMF response?](https://forum.inductiveautomation.com/t/ht503-voice-alarming-but-no-dtmf-response/18163)
**Author:** [@nculp](https://forum.inductiveautomation.com/u/nculp)\ **Replies:** 1\ **Last updated:** [May 25, 2018, 8:09am UTC](https://forum.inductiveautomation.com/t/ht503-voice-alarming-but-no-dtmf-response/18163 "2018-05-25T08:09:13Z")
I'm currently using Ignition v7.9.7 with the voice alarm module and a Grandstream HT503 gateway. I'm able to receive calls from the gateway just fine, and I hear "This is an Ignition alarm notification. Please press any … --- ## [Keeping the selected row in a powertable?](https://forum.inductiveautomation.com/t/keeping-the-selected-row-in-a-powertable/21751)
**Author:** [@mazeyrat](https://forum.inductiveautomation.com/u/mazeyrat)\ **Replies:** 1\ **Last updated:** [January 8, 2019, 9:21pm UTC](https://forum.inductiveautomation.com/t/keeping-the-selected-row-in-a-powertable/21751 "2019-01-08T21:21:41Z")
I have a power table with data binded to an expression returning a source dataset. User can select only one row. When new data are added or dateted in the source dataset, I would like to keep the row selected by the user… [Previous page](https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=1323) [Next page](https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=1325)