# Ignition **URL:** https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=1536 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 1537 --- ## [Update function in Ignition Gateway](https://forum.inductiveautomation.com/t/update-function-in-ignition-gateway/8173)
**Author:** [@drumdubb](https://forum.inductiveautomation.com/u/drumdubb)\ **Replies:** 0\ **Last updated:** [March 19, 2014, 2:35pm UTC](https://forum.inductiveautomation.com/t/update-function-in-ignition-gateway/8173 "2014-03-19T14:35:56Z")
It would be nice to have a button on the ignition gateway page that will run an update on the software version. If not this, than at least a link to the current version or a download link next to the prompt that says a n… --- ## [Docked window is shifted within screen when openWindow cmd r](https://forum.inductiveautomation.com/t/docked-window-is-shifted-within-screen-when-openwindow-cmd-r/8172)
**Author:** [@gljuk](https://forum.inductiveautomation.com/u/gljuk)\ **Replies:** 1\ **Last updated:** [March 19, 2014, 2:21pm UTC](https://forum.inductiveautomation.com/t/docked-window-is-shifted-within-screen-when-openwindow-cmd-r/8172 "2014-03-19T14:21:37Z")
Hi, Ignition team! Upgraded Ignition from 7.5 to the latest 7.6 build recently. There is a problem with docked windows. Let me try to explain. Screen is divided into several parts. In the center we have a main windo… --- ## [Strange toDataSet error](https://forum.inductiveautomation.com/t/strange-todataset-error/8170)
**Author:** [@gekkoman](https://forum.inductiveautomation.com/u/gekkoman)\ **Replies:** 1\ **Last updated:** [March 19, 2014, 6:02am UTC](https://forum.inductiveautomation.com/t/strange-todataset-error/8170 "2014-03-19T06:02:28Z")
Greetings, am making a toDataSet Call.....works with some data but not with other data. I may be just not seeing something but both arrays look ok. The mixed unicode/string does not appear to cause any problems as it… --- ## [Transactions execute but no data appears](https://forum.inductiveautomation.com/t/transactions-execute-but-no-data-appears/8163)
**Author:** [@porksmash](https://forum.inductiveautomation.com/u/porksmash)\ **Replies:** 2\ **Last updated:** [March 18, 2014, 6:41pm UTC](https://forum.inductiveautomation.com/t/transactions-execute-but-no-data-appears/8163 "2014-03-18T18:41:08Z")
I'm having a very strange issue with MySQL and some Ignition transactions. I have 8 transactions I trigger at the same time to send part data for 8 parts into the same table. When they are triggered, all of the transacti… --- ## [Insert statement Question](https://forum.inductiveautomation.com/t/insert-statement-question/8165)
**Author:** [@drewdin](https://forum.inductiveautomation.com/u/drewdin)\ **Replies:** 3\ **Last updated:** [March 18, 2014, 6:34pm UTC](https://forum.inductiveautomation.com/t/insert-statement-question/8165 "2014-03-18T18:34:25Z")
I have a basic Insert statement: INSERT INTO my\_table (column\_1, column\_2) VALUES ('X', 'Y') I want to insert multiple values like so: INSERT INTO my\_table (column\_1, column\_2) VALUES ('A', 'B'), ('C', 'D'), ('E',… --- ## [jsonEncode and jsonDecode issue with special characters](https://forum.inductiveautomation.com/t/jsonencode-and-jsondecode-issue-with-special-characters/8109)
**Author:** [@Javachon](https://forum.inductiveautomation.com/u/Javachon)\ **Replies:** 7\ **Last updated:** [March 18, 2014, 5:21pm UTC](https://forum.inductiveautomation.com/t/jsonencode-and-jsondecode-issue-with-special-characters/8109 "2014-03-18T17:21:23Z")
Hi, is there a limitation on the supported characters for json encoding ? When running this code tagsArray = \[\] tagsArray.append(\["bébé"\]) TagsAsJSON = system.util.jsonEncode(tagsArray) tagsArray = system.util.jsonDec… --- ## [SQL Server Scalar Function Works in Client, Fails in GW Tag](https://forum.inductiveautomation.com/t/sql-server-scalar-function-works-in-client-fails-in-gw-tag/8153)
**Author:** [@mlangdon](https://forum.inductiveautomation.com/u/mlangdon)\ **Replies:** 2\ **Last updated:** [March 18, 2014, 5:15pm UTC](https://forum.inductiveautomation.com/t/sql-server-scalar-function-works-in-client-fails-in-gw-tag/8153 "2014-03-18T17:15:06Z")
I have a SQL function dbo.machine\_availablity() with a parameter of int and a return value of float. In a Client tag, it returns a number between 0 & 100 as expected. In a gateway tag with identical syntax and pa… --- ## [How to connect the ignition OPC UA sever with prosys client?](https://forum.inductiveautomation.com/t/how-to-connect-the-ignition-opc-ua-sever-with-prosys-client/4858)
**Author:** [@wengzijue](https://forum.inductiveautomation.com/u/wengzijue)\ **Replies:** 6\ **Last updated:** [March 18, 2014, 5:09pm UTC](https://forum.inductiveautomation.com/t/how-to-connect-the-ignition-opc-ua-sever-with-prosys-client/4858 "2014-03-18T17:09:43Z")
How to connect the OPC UA sever with prosys client? Using prosys example opc ua client (Prosys-OPC-UA-Java-SDK-Client-Server-Evaluation-1.3.0-3321)to connect to ignition OPC UA Sever,but failed . Whatis the problem,than… --- ## [Filter a table by tag from a text field](https://forum.inductiveautomation.com/t/filter-a-table-by-tag-from-a-text-field/8164)
**Author:** [@controlsim](https://forum.inductiveautomation.com/u/controlsim)\ **Replies:** 8\ **Last updated:** [March 18, 2014, 4:55pm UTC](https://forum.inductiveautomation.com/t/filter-a-table-by-tag-from-a-text-field/8164 "2014-03-18T16:55:13Z")
Hi, I trying to filter a table, the data come from a transaction group, and the table is named "group\_table", then i have a text field for enter the name of a tag. I have this on the table: \[color=#FF0000\]SELECT {Roo… --- ## [Start a timer when a bit goes high?](https://forum.inductiveautomation.com/t/start-a-timer-when-a-bit-goes-high/8166)
**Author:** [@SonicClang](https://forum.inductiveautomation.com/u/SonicClang)\ **Replies:** 2\ **Last updated:** [March 18, 2014, 4:53pm UTC](https://forum.inductiveautomation.com/t/start-a-timer-when-a-bit-goes-high/8166 "2014-03-18T16:53:42Z")
I'm wondering if Ignition can do this, and if so, what the best route would be. I want to start a timer when a bit goes high. The bit would be an OPC tag, but the timer would be in Ignition. Ideas? EDIT: Oh, and when t… --- ## [Ignition OPC-UA connection issue](https://forum.inductiveautomation.com/t/ignition-opc-ua-connection-issue/8157)
**Author:** [@mwasim](https://forum.inductiveautomation.com/u/mwasim)\ **Replies:** 3\ **Last updated:** [March 18, 2014, 2:54pm UTC](https://forum.inductiveautomation.com/t/ignition-opc-ua-connection-issue/8157 "2014-03-18T14:54:27Z")
I am using Ignition demo version 7.6.3 and most of the time I get this error message when I reset trial version. "\[color=#FF0000\]Cannot browse connection "Ignition OPC-UA Server" when connection state is CONNECTING\[/co… --- ## [Ignition Server in Title Bar](https://forum.inductiveautomation.com/t/ignition-server-in-title-bar/8152)
**Author:** [@mluedecke](https://forum.inductiveautomation.com/u/mluedecke)\ **Replies:** 2\ **Last updated:** [March 17, 2014, 2:45pm UTC](https://forum.inductiveautomation.com/t/ignition-server-in-title-bar/8152 "2014-03-17T14:45:31Z")
For users that are opening designers for projects on multiple Ignition gateways, it would be useful to have the Ignition gateway name included in the title bar. Otherwise, if editing a project with the same name across … --- ## [Database Storage Unavailable](https://forum.inductiveautomation.com/t/database-storage-unavailable/8141)
**Author:** [@bryce.troy](https://forum.inductiveautomation.com/u/bryce.troy)\ **Replies:** 5\ **Last updated:** [March 17, 2014, 1:55pm UTC](https://forum.inductiveautomation.com/t/database-storage-unavailable/8141 "2014-03-17T13:55:05Z")
Trying to log data using SQLTags Historian and all data is getting stuck in the Store and Forward engine. MySQL database connection appears valid, and SQLTags Providers shows 14 History Tags in the Default Historical sca… --- ## [Transaction groups partial accumulate value](https://forum.inductiveautomation.com/t/transaction-groups-partial-accumulate-value/8158)
**Author:** [@kpina](https://forum.inductiveautomation.com/u/kpina)\ **Replies:** 0\ **Last updated:** [March 17, 2014, 9:35am UTC](https://forum.inductiveautomation.com/t/transaction-groups-partial-accumulate-value/8158 "2014-03-17T09:35:19Z")
Hello everyone. In my project we need to historicizing an energy value. This value is increasing over time: Example value 1: 10000 One hour later value 2: 10350 We want to record this partial value, 350, in o… --- ## [Use Ignition as a front-end for a database application?](https://forum.inductiveautomation.com/t/use-ignition-as-a-front-end-for-a-database-application/8155)
**Author:** [@SonicClang](https://forum.inductiveautomation.com/u/SonicClang)\ **Replies:** 3\ **Last updated:** [March 15, 2014, 12:08am UTC](https://forum.inductiveautomation.com/t/use-ignition-as-a-front-end-for-a-database-application/8155 "2014-03-15T00:08:34Z")
I'm wondering if it's possible to use Ignition as a front-end for a database, kind of like using Access as a front-end for a SQL server. I'm planning on making a SQL table to store alarm set points for different projects… --- ## [Alarm Test pipeline error - Uncaught Throwable during notifi](https://forum.inductiveautomation.com/t/alarm-test-pipeline-error-uncaught-throwable-during-notifi/8154)
**Author:** [@seanwaite](https://forum.inductiveautomation.com/u/seanwaite)\ **Replies:** 1\ **Last updated:** [March 14, 2014, 8:05pm UTC](https://forum.inductiveautomation.com/t/alarm-test-pipeline-error-uncaught-throwable-during-notifi/8154 "2014-03-14T20:05:41Z")
Trying to configure Ignition 7.6.5-RC4 to send test alarm. On the SMTP server see no attempted connection from Ignition server. As far as I can tell (not really knowing java) seems something is stopping Ignition from eve… --- ## [Smart TV via mobile vs Thin Client](https://forum.inductiveautomation.com/t/smart-tv-via-mobile-vs-thin-client/8147)
**Author:** [@WildeKurt](https://forum.inductiveautomation.com/u/WildeKurt)\ **Replies:** 3\ **Last updated:** [March 14, 2014, 11:46am UTC](https://forum.inductiveautomation.com/t/smart-tv-via-mobile-vs-thin-client/8147 "2014-03-14T11:46:24Z")
We have a client that has their heart set on using a Smart TV as a plant-floor dashboard. From what I gather this is do-able as a mobile device (no Java) but I'm inclined to recommend they use a thin client or PC that r… --- ## [Cannot log in to Designer on Backup Gateway](https://forum.inductiveautomation.com/t/cannot-log-in-to-designer-on-backup-gateway/8080)
**Author:** [@dfenter](https://forum.inductiveautomation.com/u/dfenter)\ **Replies:** 4\ **Last updated:** [March 13, 2014, 10:02pm UTC](https://forum.inductiveautomation.com/t/cannot-log-in-to-designer-on-backup-gateway/8080 "2014-03-13T22:02:49Z")
My master Ignition gateway failed, and while I can launch the designer from the backup gateway, when I try to login, I get denied. How can I login using the backup gateway? Also, how can I change the redundant backup … --- ## [Force tab width via script?](https://forum.inductiveautomation.com/t/force-tab-width-via-script/8149)
**Author:** [@lisawas](https://forum.inductiveautomation.com/u/lisawas)\ **Replies:** 1\ **Last updated:** [March 13, 2014, 6:31pm UTC](https://forum.inductiveautomation.com/t/force-tab-width-via-script/8149 "2014-03-13T18:31:47Z")
Is there a way to force the width of tabs in the tabstrip? I used some HTML to make the display text wrap, but the tab width seems to include the length of the invisible HTML. I'd happily script around it, but the tabs… --- ## [Does Ignition support Siemens S7-1500?](https://forum.inductiveautomation.com/t/does-ignition-support-siemens-s7-1500/8148)
**Author:** [@george](https://forum.inductiveautomation.com/u/george)\ **Replies:** 2\ **Last updated:** [March 13, 2014, 4:46pm UTC](https://forum.inductiveautomation.com/t/does-ignition-support-siemens-s7-1500/8148 "2014-03-13T16:46:13Z")
Pretty much as the thread title says. I understand it currently connects to S7-300, S7-400, S7-1200. But will the current Siemens driver talk to an S7-1500 PLC? I've been asked by someone who (I guess) is consideri… --- ## [Ipads](https://forum.inductiveautomation.com/t/ipads/7915)
**Author:** [@HALW80](https://forum.inductiveautomation.com/u/HALW80)\ **Replies:** 5\ **Last updated:** [March 13, 2014, 11:03am UTC](https://forum.inductiveautomation.com/t/ipads/7915 "2014-03-13T11:03:03Z")
We had developed our application and adjusted our mobile client custom viewport to suit an ipad2. This took alot time to get it fit screen fully. Fit to device did not seem to work. Our customer has got a few ipad Airs n… --- ## [Delete rows from a table](https://forum.inductiveautomation.com/t/delete-rows-from-a-table/8146)
**Author:** [@controlsim](https://forum.inductiveautomation.com/u/controlsim)\ **Replies:** 2\ **Last updated:** [March 12, 2014, 10:22pm UTC](https://forum.inductiveautomation.com/t/delete-rows-from-a-table/8146 "2014-03-12T22:22:35Z")
hi, i trying to delete row from a table but i get an error, i have a dropdown list and a button with this script: delete = event.source.parent.getComponent('Dropdown').selectedStringValue system.db.runUpdateQuery("… --- ## [SQL optimization](https://forum.inductiveautomation.com/t/sql-optimization/8145)
**Author:** [@Tim](https://forum.inductiveautomation.com/u/Tim)\ **Replies:** 1\ **Last updated:** [March 12, 2014, 5:09pm UTC](https://forum.inductiveautomation.com/t/sql-optimization/8145 "2014-03-12T17:09:31Z")
I intermittently (25% of the time) receive the following error when executing a SQL query, the remaining time the desired results are achieved. I am trying to set the sort order for a new set of records after they have … --- ## [Recipe Module database](https://forum.inductiveautomation.com/t/recipe-module-database/8144)
**Author:** [@ssorrell](https://forum.inductiveautomation.com/u/ssorrell)\ **Replies:** 2\ **Last updated:** [March 12, 2014, 3:24pm UTC](https://forum.inductiveautomation.com/t/recipe-module-database/8144 "2014-03-12T15:24:27Z")
I was hoping to be able to find the tables for the recipe module to at least verify the import, but also to possibly do queries against it. I have looked over both the HSQL tables and the tables in my local MS SQL Serve… --- ## [Historical chart problem](https://forum.inductiveautomation.com/t/historical-chart-problem/8114)
**Author:** [@Serhii](https://forum.inductiveautomation.com/u/Serhii)\ **Replies:** 5\ **Last updated:** [March 12, 2014, 7:20am UTC](https://forum.inductiveautomation.com/t/historical-chart-problem/8114 "2014-03-12T07:20:34Z")
Hello! On video http://dropmefiles.com/kjPls you can see 2 problems 1) Not correct displaying discrete output when zoom out the time. 2) All values goes constant at 2014-03-01 00:00:00, but if i go to zoom time like in 1… --- ## [Single Column Transaction Groups](https://forum.inductiveautomation.com/t/single-column-transaction-groups/8143)
**Author:** [@bridress](https://forum.inductiveautomation.com/u/bridress)\ **Replies:** 1\ **Last updated:** [March 12, 2014, 12:06am UTC](https://forum.inductiveautomation.com/t/single-column-transaction-groups/8143 "2014-03-12T00:06:02Z")
Hello, I'm trying to create a block (or standard) transaction group that will write a group of tags on a set schedule to a table I define. I need one value column to store the floating point values. There will be two… --- ## ['Ghosting' issue on the Client](https://forum.inductiveautomation.com/t/ghosting-issue-on-the-client/7932)
**Author:** [@cacordova](https://forum.inductiveautomation.com/u/cacordova)\ **Replies:** 13\ **Last updated:** [March 11, 2014, 11:26pm UTC](https://forum.inductiveautomation.com/t/ghosting-issue-on-the-client/7932 "2014-03-11T23:26:43Z")
We've been having this 'ghosting' issue on the tables when we launch it on the client, when we check back on the designer it looks ok and it looks right but when launched on the client and we try to select a row the 'gho… --- ## [Automating pdf reports creation from gateway script](https://forum.inductiveautomation.com/t/automating-pdf-reports-creation-from-gateway-script/8031)
**Author:** [@Javachon](https://forum.inductiveautomation.com/u/Javachon)\ **Replies:** 3\ **Last updated:** [March 11, 2014, 9:50pm UTC](https://forum.inductiveautomation.com/t/automating-pdf-reports-creation-from-gateway-script/8031 "2014-03-11T21:50:37Z")
We have a requirement, quite typical, to periodically create and save a bunch of predefined reports. In our case, we have many reports that we need to create and save per many plants on a monthly or daily basis. We are… --- ## [Help! system.db.runPrepUpdate error](https://forum.inductiveautomation.com/t/help-system-db-runprepupdate-error/8140)
**Author:** [@controlsim](https://forum.inductiveautomation.com/u/controlsim)\ **Replies:** 2\ **Last updated:** [March 11, 2014, 7:53pm UTC](https://forum.inductiveautomation.com/t/help-system-db-runprepupdate-error/8140 "2014-03-11T19:53:10Z")
Hi, I have this database created and I want to insert data but I get error \[i\]CREATE TABLE inventory ( id int NOT NULL AUTO\_INCREMENT, name varchar(255) NOT NULL, description varchar(255) not null, PRIMARY KEY (id) )… --- ## [App scripts in gateway](https://forum.inductiveautomation.com/t/app-scripts-in-gateway/8139)
**Author:** [@JordanCClark](https://forum.inductiveautomation.com/u/JordanCClark)\ **Replies:** 2\ **Last updated:** [March 11, 2014, 5:46pm UTC](https://forum.inductiveautomation.com/t/app-scripts-in-gateway/8139 "2014-03-11T17:46:25Z")
Referencing my topic on how to handily break a script by making it too large: http://inductiveautomation.com/forum/viewtopic.php?f=25&t=11960 And also remembering this thread: http://inductiveautomation.com/forum/viewt… [Previous page](https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=1535) [Next page](https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=1537)