# Latest **URL:** https://forum.inductiveautomation.com/latest.md?page=1494 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 1495 --- ## [Dropdown bind to SQL query, but allow no selection](https://forum.inductiveautomation.com/t/dropdown-bind-to-sql-query-but-allow-no-selection/26498)
**Author:** [@jlandwerlen](https://forum.inductiveautomation.com/u/jlandwerlen)\ **Replies:** 2\ **Last updated:** [July 13, 2019, 1:03pm UTC](https://forum.inductiveautomation.com/t/dropdown-bind-to-sql-query-but-allow-no-selection/26498 "2019-07-13T13:03:34Z")
Using 7.9.10, I have a dropdown list bound to SQL query. This works fine. What if I want to deselect and have nothing selected? How can this be accomplished? Right now, the only available choices are what’s returned … --- ## [Edit dataset, then copy to SQL?](https://forum.inductiveautomation.com/t/edit-dataset-then-copy-to-sql/26494)
**Author:** [@jlandwerlen](https://forum.inductiveautomation.com/u/jlandwerlen)\ **Replies:** 6\ **Last updated:** [July 13, 2019, 1:02pm UTC](https://forum.inductiveautomation.com/t/edit-dataset-then-copy-to-sql/26494 "2019-07-13T13:02:35Z")
Looking for advice, and direction as well. Using 7.9.10, MySQL. I have a table with several rows that I allow changes. Right now you don’t edit the from within table, yet with selected row I move data into dropdown bo… --- ## [toCSV vs exportCSV](https://forum.inductiveautomation.com/t/tocsv-vs-exportcsv/26537)
**Author:** [@zxcslo](https://forum.inductiveautomation.com/u/zxcslo)\ **Replies:** 1\ **Last updated:** [July 13, 2019, 11:31am UTC](https://forum.inductiveautomation.com/t/tocsv-vs-exportcsv/26537 "2019-07-13T11:31:47Z")
When I use system.dataset.toCSV to export Russian translations from table to .csv, I get this: When I use system.dataset.exportCSV, I get this: To import csv there’s only one function: system.dataset.fromCSV, w… --- ## [TabStrip Arrows blocking tab](https://forum.inductiveautomation.com/t/tabstrip-arrows-blocking-tab/26509)
**Author:** [@brian.ankeny](https://forum.inductiveautomation.com/u/brian.ankeny)\ **Replies:** 1\ **Last updated:** [July 12, 2019, 10:19pm UTC](https://forum.inductiveautomation.com/t/tabstrip-arrows-blocking-tab/26509 "2019-07-12T22:19:07Z")
We recently noticed an issue with an existing tab strip where a set of right/left arrows have appeared overlayed over one of the tabs (We recently upgraded to 7.9.12 but are not sure if this caused it). Pressing the arro… --- ## [System.report.executeanddistribute - time zone issue?](https://forum.inductiveautomation.com/t/system-report-executeanddistribute-time-zone-issue/26530)
**Author:** [@kwj](https://forum.inductiveautomation.com/u/kwj)\ **Replies:** 0\ **Last updated:** [July 12, 2019, 8:38pm UTC](https://forum.inductiveautomation.com/t/system-report-executeanddistribute-time-zone-issue/26530 "2019-07-12T20:38:54Z")
I am pulling two dates (saved in postgresql with timezone) for a report. When that report is displayed in a viewer with the dates plugged in, everything is displayed correctly. When I use the same dates and report, but p… --- ## [Disable Right Click in Browser](https://forum.inductiveautomation.com/t/disable-right-click-in-browser/26529)
**Author:** [@apgilber](https://forum.inductiveautomation.com/u/apgilber)\ **Replies:** 0\ **Last updated:** [July 12, 2019, 8:37pm UTC](https://forum.inductiveautomation.com/t/disable-right-click-in-browser/26529 "2019-07-12T20:37:56Z")
I have a press and hold application in a perspective session that is running on chrome. I was able to disable the press and hold function in Windows but when you press and hold the button on the screen the right click m… --- ## [Window information](https://forum.inductiveautomation.com/t/window-information/21549)
**Author:** [@alex.cordova.ee](https://forum.inductiveautomation.com/u/alex.cordova.ee)\ **Replies:** 10\ **Last updated:** [July 12, 2019, 8:05pm UTC](https://forum.inductiveautomation.com/t/window-information/21549 "2019-07-12T20:05:46Z")
How do I get information to tag on which window is open. Not sure if I can assign numbers to windows or just grab the names of them. Reason being, I have a filter button on alarm banner. The banner is docked under ever… --- ## [Detect Ignition 8.0 or 7.9 in script](https://forum.inductiveautomation.com/t/detect-ignition-8-0-or-7-9-in-script/26521)
**Author:** [@mazeyrat](https://forum.inductiveautomation.com/u/mazeyrat)\ **Replies:** 5\ **Last updated:** [July 12, 2019, 6:58pm UTC](https://forum.inductiveautomation.com/t/detect-ignition-8-0-or-7-9-in-script/26521 "2019-07-12T18:58:53Z")
Is there a way to detect in Gateway/Client script if the version is Ignition 8.0 or Ignition 7.9 --- ## [Client fallback mechanism in 8.x vs 7.9](https://forum.inductiveautomation.com/t/client-fallback-mechanism-in-8-x-vs-7-9/26474)
**Author:** [@florint](https://forum.inductiveautomation.com/u/florint)\ **Replies:** 1\ **Last updated:** [July 12, 2019, 6:08pm UTC](https://forum.inductiveautomation.com/t/client-fallback-mechanism-in-8-x-vs-7-9/26474 "2019-07-12T18:08:51Z")
There seem to be a difference between Ignition 7.9 and 8.02 in terms of client fallback behavior. I have two Ignition servers - A and B - configured as “Independent”. The clients connect to server A (while server B is n… --- ## [Setting Page Problems](https://forum.inductiveautomation.com/t/setting-page-problems/26523)
**Author:** [@kstewart](https://forum.inductiveautomation.com/u/kstewart)\ **Replies:** 0\ **Last updated:** [July 12, 2019, 5:39pm UTC](https://forum.inductiveautomation.com/t/setting-page-problems/26523 "2019-07-12T17:39:52Z")
I am doing a settings popup window for all of the different main windows we have. I am having a problem though, I would like the user to be able to adjust the font to what size they want but the font option does not have… --- ## [Custom Store&Forward Fails - Truncates VARBINARY Field Data](https://forum.inductiveautomation.com/t/custom-store-forward-fails-truncates-varbinary-field-data/26516)
**Author:** [@MikeAllgood](https://forum.inductiveautomation.com/u/MikeAllgood)\ **Replies:** 0\ **Last updated:** [July 12, 2019, 4:41pm UTC](https://forum.inductiveautomation.com/t/custom-store-forward-fails-truncates-varbinary-field-data/26516 "2019-07-12T16:41:23Z")
I’m trying to build a custom Store & Forward component in a project that will take test data from a local MS SQL DB and insert it into a remote MS SQL DB in an Azure Cloud server. One of the fields in the data being cop… --- ## [Ignition Edge on arm32hf device](https://forum.inductiveautomation.com/t/ignition-edge-on-arm32hf-device/25622)
**Author:** [@yurichamarelli](https://forum.inductiveautomation.com/u/yurichamarelli)\ **Replies:** 17\ **Last updated:** [July 12, 2019, 4:33pm UTC](https://forum.inductiveautomation.com/t/ignition-edge-on-arm32hf-device/25622 "2019-07-12T16:33:53Z")
Hello all, We been working on implementing the the Ignition Edge version for the armv32hf , in a debian based armv32hf target. we have correctly installed and configured the JRE arm32 version 8, and followed through pr… --- ## [\[14424\] Cannot Monitor SFC Defined in Base Project](https://forum.inductiveautomation.com/t/14424-cannot-monitor-sfc-defined-in-base-project/26290)
**Author:** [@rttwge](https://forum.inductiveautomation.com/u/rttwge)\ **Replies:** 4\ **Last updated:** [July 12, 2019, 4:08pm UTC](https://forum.inductiveautomation.com/t/14424-cannot-monitor-sfc-defined-in-base-project/26290 "2019-07-12T16:08:33Z")
Hi, I have an SFC in an inheritable project, I’ve created another project which inherits from that project and successfully start the SFC. I see the SFC running from the web portal plus I can set tags etc. etc. and have… --- ## [\[Bug-14209\] Perspective - Style classes not working on table header group](https://forum.inductiveautomation.com/t/bug-14209-perspective-style-classes-not-working-on-table-header-group/25520)
**Author:** [@alan\_pereira](https://forum.inductiveautomation.com/u/alan_pereira)\ **Replies:** 2\ **Last updated:** [July 12, 2019, 3:45pm UTC](https://forum.inductiveautomation.com/t/bug-14209-perspective-style-classes-not-working-on-table-header-group/25520 "2019-07-12T15:45:22Z")
The title says it all, but here's a screenshot: Basically, if you apply styles directly from the properties, it works (e.g. fontStyle on the screenshot), but if you use style classes it won't do anything. --- ## [Power Table Formatting](https://forum.inductiveautomation.com/t/power-table-formatting/26511)
**Author:** [@Ranga.Katti](https://forum.inductiveautomation.com/u/Ranga.Katti)\ **Replies:** 2\ **Last updated:** [July 12, 2019, 2:59pm UTC](https://forum.inductiveautomation.com/t/power-table-formatting/26511 "2019-07-12T14:59:24Z")
I am binding a power table data through an sql query. Sql data type is char(50) but actual data length is only 10 char long. If I use TRIM command in sql query, I lose column headings in power table. Is there a different… --- ## [\[Bug-14458\] Changes saved if clicking cancel on 'Edit Group Tag'](https://forum.inductiveautomation.com/t/bug-14458-changes-saved-if-clicking-cancel-on-edit-group-tag/26057)
**Author:** [@grietveld](https://forum.inductiveautomation.com/u/grietveld)\ **Replies:** 5\ **Last updated:** [July 12, 2019, 2:07pm UTC](https://forum.inductiveautomation.com/t/bug-14458-changes-saved-if-clicking-cancel-on-edit-group-tag/26057 "2019-07-12T14:07:53Z")
I’m on the 8.0.2 Release. It appears that if I make a change(such as changing the name) and hit cancel instead of OK or Apply, the changes are still saved to the transaction. I’m guessing this isn’t intentional behavior? … --- ## [Java Specs per Version](https://forum.inductiveautomation.com/t/java-specs-per-version/26506)
**Author:** [@dkhayes117](https://forum.inductiveautomation.com/u/dkhayes117)\ **Replies:** 1\ **Last updated:** [July 12, 2019, 12:41pm UTC](https://forum.inductiveautomation.com/t/java-specs-per-version/26506 "2019-07-12T12:41:11Z")
Where can I find the details on which versions have embedded Java for clients/gateways? I’m currently on 7.9.10 looking to go to 7.9.11 soon, and hopefully 8.0.x next. Also would like to know the Java version details. --- ## [Chart Strange behaviour](https://forum.inductiveautomation.com/t/chart-strange-behaviour/26197)
**Author:** [@nagewaza1009](https://forum.inductiveautomation.com/u/nagewaza1009)\ **Replies:** 15\ **Last updated:** [July 12, 2019, 11:30am UTC](https://forum.inductiveautomation.com/t/chart-strange-behaviour/26197 "2019-07-12T11:30:08Z")
Hello everyone, I have had a problem for a few days. Some of my charts and the records of the historian tags in the database don’t make sense at all. To explain my problem, here is an example : the Tag TT105. If you hav… --- ## [Email Notification block consolidation](https://forum.inductiveautomation.com/t/email-notification-block-consolidation/26504)
**Author:** [@annr](https://forum.inductiveautomation.com/u/annr)\ **Replies:** 0\ **Last updated:** [July 12, 2019, 10:29am UTC](https://forum.inductiveautomation.com/t/email-notification-block-consolidation/26504 "2019-07-12T10:29:01Z")
Hi all, I have a doubt about the Notification Block consolidation Delay (sec)= 15 seconds Frequency (sec)= 60 seconds Alarm 1 enters the pipeline and has to wait for 15 seconds to be sent Alarm 2 enters the pipeline… --- ## [Scan classes and gateway scriptcs - time precision](https://forum.inductiveautomation.com/t/scan-classes-and-gateway-scriptcs-time-precision/26473)
**Author:** [@szcz](https://forum.inductiveautomation.com/u/szcz)\ **Replies:** 2\ **Last updated:** [July 12, 2019, 4:51am UTC](https://forum.inductiveautomation.com/t/scan-classes-and-gateway-scriptcs-time-precision/26473 "2019-07-12T04:51:00Z")
Greetings, I have scan-class and gateway scripts-related question. With scan class, we can set how often it is going to run. The same we can do with gateway scripts (e.g. run every 10 seconds). I just wanted to ask how … --- ## [\[FEATURE-14434\] Perspective Sparkline Range won't expand](https://forum.inductiveautomation.com/t/feature-14434-perspective-sparkline-range-wont-expand/26438)
**Author:** [@dkylep](https://forum.inductiveautomation.com/u/dkylep)\ **Replies:** 5\ **Last updated:** [July 11, 2019, 9:05pm UTC](https://forum.inductiveautomation.com/t/feature-14434-perspective-sparkline-range-wont-expand/26438 "2019-07-11T21:05:31Z")
I’ve been eagerly waiting an update to the Sparkline chart so I’ve downloaded the nightly version b2019070802 to test out the Sparkline enhancements. One issue that I’ve run into is the Range will not expand beyond the … --- ## [Module Signer Timestamps](https://forum.inductiveautomation.com/t/module-signer-timestamps/26489)
**Author:** [@THK](https://forum.inductiveautomation.com/u/THK)\ **Replies:** 6\ **Last updated:** [July 11, 2019, 7:20pm UTC](https://forum.inductiveautomation.com/t/module-signer-timestamps/26489 "2019-07-11T19:20:03Z")
Does the module signing tool timestamp the signed module? --- ## [Named query to insert float to sql, error unable to coerce to number](https://forum.inductiveautomation.com/t/named-query-to-insert-float-to-sql-error-unable-to-coerce-to-number/21143)
**Author:** [@bebel](https://forum.inductiveautomation.com/u/bebel)\ **Replies:** 3\ **Last updated:** [July 11, 2019, 7:05pm UTC](https://forum.inductiveautomation.com/t/named-query-to-insert-float-to-sql-error-unable-to-coerce-to-number/21143 "2019-07-11T19:05:16Z")
I have a named query to insert a record into a sql database table One of the data types in the table is float. In the Parameters portion of the named query I have tried Float4 and Float8 In the button that triggers the n… --- ## [\[Bug-14451,14448,13743,11792\]V8.0.3 UDT Definitions & Parameters](https://forum.inductiveautomation.com/t/bug-14451-14448-13743-11792-v8-0-3-udt-definitions-parameters/25848)
**Author:** [@rberghammer](https://forum.inductiveautomation.com/u/rberghammer)\ **Replies:** 1\ **Last updated:** [July 11, 2019, 6:10pm UTC](https://forum.inductiveautomation.com/t/bug-14451-14448-13743-11792-v8-0-3-udt-definitions-parameters/25848 "2019-07-11T18:10:21Z")
Using a recent nightly build of 8.0.3, I have tried creating a UDT with an alarm pre-configured. Some alarm properties are bound to parameters of the UDT such as display path, label, priority, etc. I have encountered q… --- ## [Vision component position differs between designer and launch](https://forum.inductiveautomation.com/t/vision-component-position-differs-between-designer-and-launch/26486)
**Author:** [@waldner](https://forum.inductiveautomation.com/u/waldner)\ **Replies:** 1\ **Last updated:** [July 11, 2019, 5:55pm UTC](https://forum.inductiveautomation.com/t/vision-component-position-differs-between-designer-and-launch/26486 "2019-07-11T17:55:10Z")
In designer, I create a main window with a label quite near its left margin, as seen in this screenshot: However, when I launch the project (windowed or maximized, no difference), the label is very far from the left … --- ## [Designer - Block Access to Database for Specific Role](https://forum.inductiveautomation.com/t/designer-block-access-to-database-for-specific-role/26455)
**Author:** [@hodgins.e](https://forum.inductiveautomation.com/u/hodgins.e)\ **Replies:** 2\ **Last updated:** [July 11, 2019, 5:41pm UTC](https://forum.inductiveautomation.com/t/designer-block-access-to-database-for-specific-role/26455 "2019-07-11T17:41:57Z")
I’ve made a user that will only have access to 1 project on our gateway. I need to make sure they cannot modify a database connection we currently have setup. Basically don’t want them to write/delete any tables we have… --- ## [Passing a table to runScript](https://forum.inductiveautomation.com/t/passing-a-table-to-runscript/26484)
**Author:** [@waldner](https://forum.inductiveautomation.com/u/waldner)\ **Replies:** 14\ **Last updated:** [July 11, 2019, 5:35pm UTC](https://forum.inductiveautomation.com/t/passing-a-table-to-runscript/26484 "2019-07-11T17:35:46Z")
In Vision, I want to use a label component which shows the number of selected rows in a table. I can get the number of selected rows in a table with .getSelectedRowCount(), so I wrote: def getSelectedRowCount(table): … --- ## [Report Schedules Problem](https://forum.inductiveautomation.com/t/report-schedules-problem/26475)
**Author:** [@MMaynard](https://forum.inductiveautomation.com/u/MMaynard)\ **Replies:** 6\ **Last updated:** [July 11, 2019, 5:27pm UTC](https://forum.inductiveautomation.com/t/report-schedules-problem/26475 "2019-07-11T17:27:16Z")
So we have a gateway that due to domain issues had its date set 2 months ahead. The scheduled reports ran and set the last run date/time to Sept 1st Now since the date was corrected after that no reports will execute a… --- ## [\[FEATURE-13287\] Unable to Copy Named Query Path If Inherited](https://forum.inductiveautomation.com/t/feature-13287-unable-to-copy-named-query-path-if-inherited/23557)
**Author:** [@Katarn](https://forum.inductiveautomation.com/u/Katarn)\ **Replies:** 2\ **Last updated:** [July 11, 2019, 4:35pm UTC](https://forum.inductiveautomation.com/t/feature-13287-unable-to-copy-named-query-path-if-inherited/23557 "2019-07-11T16:35:04Z")
Named Queries typically allow for copying of paths, but in the instance a Named Query is an inherited resource, the only option in the context menu is “Override Resource”. Even when a Named Query is inherited, the optio… --- ## [Any ideas on how I can search for an Ip address (on a client window) among all of my OPC devices connected?](https://forum.inductiveautomation.com/t/any-ideas-on-how-i-can-search-for-an-ip-address-on-a-client-window-among-all-of-my-opc-devices-connected/26450)
**Author:** [@Lalillo1](https://forum.inductiveautomation.com/u/Lalillo1)\ **Replies:** 2\ **Last updated:** [July 11, 2019, 4:05pm UTC](https://forum.inductiveautomation.com/t/any-ideas-on-how-i-can-search-for-an-ip-address-on-a-client-window-among-all-of-my-opc-devices-connected/26450 "2019-07-11T16:05:54Z")
Any ideas on how I can search for an Ip address (on a client window) among all of my OPC devices connected? Any built-in script functions that would allow me to design a window that searches all of the ip addresses from… [Previous page](https://forum.inductiveautomation.com/latest.md?page=1493) [Next page](https://forum.inductiveautomation.com/latest.md?page=1495)