# Archived Topics **URL:** https://forum.inductiveautomation.com/c/archived-topics/9.md?page=14 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 15 --- ## [Printing A Window](https://forum.inductiveautomation.com/t/printing-a-window/2435)
**Author:** [@raw1312](https://forum.inductiveautomation.com/u/raw1312)\ **Replies:** 2\ **Last updated:** [December 17, 2010, 7:03pm UTC](https://forum.inductiveautomation.com/t/printing-a-window/2435 "2010-12-17T19:03:16Z")
I am printing a window but I dont want my print button visible when printed. Not sure how to hide it just for the print view. --- ## [Table Column Header](https://forum.inductiveautomation.com/t/table-column-header/2404)
**Author:** [@Pat](https://forum.inductiveautomation.com/u/Pat)\ **Replies:** 1\ **Last updated:** [December 10, 2010, 11:56pm UTC](https://forum.inductiveautomation.com/t/table-column-header/2404 "2010-12-10T23:56:20Z")
Is there a way to remove the bold style applied to the Table column header? Also is it possible to remove/change the background gradient applied to the column header? --- ## [Database Application](https://forum.inductiveautomation.com/t/database-application/2395)
**Author:** [@lmcgonigal](https://forum.inductiveautomation.com/u/lmcgonigal)\ **Replies:** 1\ **Last updated:** [December 6, 2010, 5:43pm UTC](https://forum.inductiveautomation.com/t/database-application/2395 "2010-12-06T17:43:45Z")
Hi All...Thanks in advance for your help. I want to build a project mgt subsystem in ignition. I have the manual printed out and have successfully connected to a SQL Srv 2008 db. I'm having problems finding in help o… --- ## ["Write\_canceled" problem](https://forum.inductiveautomation.com/t/write-canceled-problem/2373)
**Author:** [@Mio](https://forum.inductiveautomation.com/u/Mio)\ **Replies:** 6\ **Last updated:** [December 2, 2010, 9:40pm UTC](https://forum.inductiveautomation.com/t/write-canceled-problem/2373 "2010-12-02T21:40:02Z")
I have an OPC error each times I start a "DB to OPC" group. Once I pass this error everything goes as it should. There's a short explanation of what I'm doing. I'm trying to download in a PLC some value from a work table… --- ## [SQL Tags Problem in FPMI Window](https://forum.inductiveautomation.com/t/sql-tags-problem-in-fpmi-window/2358)
**Author:** [@skallepalli](https://forum.inductiveautomation.com/u/skallepalli)\ **Replies:** 3\ **Last updated:** [December 2, 2010, 8:47am UTC](https://forum.inductiveautomation.com/t/sql-tags-problem-in-fpmi-window/2358 "2010-12-02T08:47:09Z")
Hi, We are facing issues with SQL Tags in FPMI. SQL tags are losing connection to the Tags and shows in Red Color. The tags will get connected after few minutes. This cycle will repeat. When the Tags are not connecte… --- ## [Need an "On Change and/or Rate" Trigger for FactorySQL](https://forum.inductiveautomation.com/t/need-an-on-change-and-or-rate-trigger-for-factorysql/2371)
**Author:** [@fahadfrq](https://forum.inductiveautomation.com/u/fahadfrq)\ **Replies:** 4\ **Last updated:** [December 1, 2010, 11:13pm UTC](https://forum.inductiveautomation.com/t/need-an-on-change-and-or-rate-trigger-for-factorysql/2371 "2010-12-01T23:13:21Z")
Hi, I have moved from RSSQL to FactorySQL and the project size which is being shifted has around 5000 groups. I have many groups in my project which have triggers configured for execution. these groups are for event … --- ## [Bring a boolean into a FPMI dataset](https://forum.inductiveautomation.com/t/bring-a-boolean-into-a-fpmi-dataset/2375)
**Author:** [@Pat](https://forum.inductiveautomation.com/u/Pat)\ **Replies:** 3\ **Last updated:** [December 1, 2010, 8:27pm UTC](https://forum.inductiveautomation.com/t/bring-a-boolean-into-a-fpmi-dataset/2375 "2010-12-01T20:27:57Z")
Using mysql-connector-java-5.0.4 and FPMI 3.3.2 I’m trying to pull a boolean from a MySQL database into a FPMI dataset. Using transformedBitIsBoolean=true in the connection string I can get the column to show as a boo… --- ## [JAR resources in JNLP file are not signed by same Certifica](https://forum.inductiveautomation.com/t/jar-resources-in-jnlp-file-are-not-signed-by-same-certifica/2376)
**Author:** [@hirzel](https://forum.inductiveautomation.com/u/hirzel)\ **Replies:** 2\ **Last updated:** [November 30, 2010, 3:31pm UTC](https://forum.inductiveautomation.com/t/jar-resources-in-jnlp-file-are-not-signed-by-same-certifica/2376 "2010-11-30T15:31:49Z")
Version 3.3.4 build 5790 This is a new installation that hasn't been up yet. When I try to launch the Designer, I get this error. Any ideas??? --- ## [Cannot run prepared statement while gateway is in disconnect](https://forum.inductiveautomation.com/t/cannot-run-prepared-statement-while-gateway-is-in-disconnect/2374)
**Author:** [@alexr](https://forum.inductiveautomation.com/u/alexr)\ **Replies:** 1\ **Last updated:** [November 29, 2010, 4:10pm UTC](https://forum.inductiveautomation.com/t/cannot-run-prepared-statement-while-gateway-is-in-disconnect/2374 "2010-11-29T16:10:53Z")
Hi, When I try to run any update sentence for SQL Server in preview mode from FactoryPMI Designer, appears me the next error: "Cannot run prepared statement while gateway is in disconnected or read-only mode" Any ide… --- ## [FSQL 4.2.10 Block Group](https://forum.inductiveautomation.com/t/fsql-4-2-10-block-group/2372)
**Author:** [@mrtweaver](https://forum.inductiveautomation.com/u/mrtweaver)\ **Replies:** 0\ **Last updated:** [November 29, 2010, 2:58pm UTC](https://forum.inductiveautomation.com/t/fsql-4-2-10-block-group/2372 "2010-11-29T14:58:30Z")
I have a block group setup and I am not sure why this is occuring but thought I would post here and see if there is something I can do to keep the problem from occuring. In the block group I have the wildcard ? specifi… --- ## [OPC item type problem](https://forum.inductiveautomation.com/t/opc-item-type-problem/2338)
**Author:** [@Mio](https://forum.inductiveautomation.com/u/Mio)\ **Replies:** 3\ **Last updated:** [November 25, 2010, 6:53pm UTC](https://forum.inductiveautomation.com/t/opc-item-type-problem/2338 "2010-11-25T18:53:20Z")
I'm using FSQL 4.2.11 with Kepware V5.4 and I have some OPC item's problem. I load in Kepware a serie of OPC tags wich is "Word" data type. When I'm looking to these tags with FSQL, they appearded to be "Integers". What… --- ## [Controlling properties of a root container](https://forum.inductiveautomation.com/t/controlling-properties-of-a-root-container/2364)
**Author:** [@DB2](https://forum.inductiveautomation.com/u/DB2)\ **Replies:** 1\ **Last updated:** [November 23, 2010, 10:23pm UTC](https://forum.inductiveautomation.com/t/controlling-properties-of-a-root-container/2364 "2010-11-23T22:23:41Z")
What is the syntax to control the 'visible' property of a root container from a different root container. I would like to use a check box in the root container turn a different container inside the root container on an… --- ## [Using variables to create component names](https://forum.inductiveautomation.com/t/using-variables-to-create-component-names/2357)
**Author:** [@DB2](https://forum.inductiveautomation.com/u/DB2)\ **Replies:** 3\ **Last updated:** [November 22, 2010, 4:06pm UTC](https://forum.inductiveautomation.com/t/using-variables-to-create-component-names/2357 "2010-11-22T16:06:24Z")
I'm trying to use a for loop to change the color state of several label. I've tried the following syntax with no success. value = fpmi.gui.color(238,238,238,255) word = 'label a' for i in range(1, 9): event.source.p… --- ## [Change background color using 'Configure Event Handler'](https://forum.inductiveautomation.com/t/change-background-color-using-configure-event-handler/2356)
**Author:** [@DB2](https://forum.inductiveautomation.com/u/DB2)\ **Replies:** 1\ **Last updated:** [November 19, 2010, 4:13pm UTC](https://forum.inductiveautomation.com/t/change-background-color-using-configure-event-handler/2356 "2010-11-19T16:13:49Z")
I bound the back ground value of a label to the click of a button. What is the correct syntax to change the value? value = '?' event.source.parent.getComponent('Label a1').background = value I've tried value = '23… --- ## [Sql escape](https://forum.inductiveautomation.com/t/sql-escape/2342)
**Author:** [@trsimmons](https://forum.inductiveautomation.com/u/trsimmons)\ **Replies:** 7\ **Last updated:** [November 17, 2010, 6:34pm UTC](https://forum.inductiveautomation.com/t/sql-escape/2342 "2010-11-17T18:34:46Z")
I have a table bound to an sql query and when a result returns that contains a field with a single quote, the query fails. How do I implement the sql escape character function? thanks travis --- ## [Dynamically changing image colors](https://forum.inductiveautomation.com/t/dynamically-changing-image-colors/34)
**Author:** [@jeff\_anderson](https://forum.inductiveautomation.com/u/jeff_anderson)\ **Replies:** 3\ **Last updated:** [November 11, 2010, 12:33am UTC](https://forum.inductiveautomation.com/t/dynamically-changing-image-colors/34 "2010-11-11T00:33:21Z")
I'd like to show my compressor changing color with the DB value "N\_convey1" as in my other post. 0 = red, 1 = green, 2 = yellow, 3 = red. The compressor is an image. Do I need to swap images or can I tie it into one of t… --- ## [Changing alert configuration settings from FPMI interface](https://forum.inductiveautomation.com/t/changing-alert-configuration-settings-from-fpmi-interface/481)
**Author:** [@apurdom](https://forum.inductiveautomation.com/u/apurdom)\ **Replies:** 7\ **Last updated:** [November 4, 2010, 11:16pm UTC](https://forum.inductiveautomation.com/t/changing-alert-configuration-settings-from-fpmi-interface/481 "2010-11-04T23:16:43Z")
I need to give end users ability to edit the FSQL OPC Item Alert Configuration settings, mainly analog trigger point and ack mode, from an FPMI client interface window. Is there any way to do this? --- ## [SQL Tag Imports as String](https://forum.inductiveautomation.com/t/sql-tag-imports-as-string/2318)
**Author:** [@cezipper](https://forum.inductiveautomation.com/u/cezipper)\ **Replies:** 1\ **Last updated:** [November 4, 2010, 9:59pm UTC](https://forum.inductiveautomation.com/t/sql-tag-imports-as-string/2318 "2010-11-04T21:59:40Z")
This may not be an issue in ignition, but I noticed that if I import tags from the OPC browser sometimes the tags are very slow to import and they have errors, such as coming in as strings instead of floats. I found I … --- ## [Simple block group problem...I guess](https://forum.inductiveautomation.com/t/simple-block-group-problem-i-guess/2295)
**Author:** [@Mio](https://forum.inductiveautomation.com/u/Mio)\ **Replies:** 3\ **Last updated:** [October 26, 2010, 9:10pm UTC](https://forum.inductiveautomation.com/t/simple-block-group-problem-i-guess/2295 "2010-10-26T21:10:30Z")
I'm using FSQL 4.2.11 to write back set point in a PLC by selecting a specific Block id. FactorySQL seems to be made for that but I can't find a way to do it. I have more than a thousand of value so I'm using block gro… --- ## [Insert manually alerts in alert\_log table](https://forum.inductiveautomation.com/t/insert-manually-alerts-in-alert-log-table/2273)
**Author:** [@Oriol](https://forum.inductiveautomation.com/u/Oriol)\ **Replies:** 2\ **Last updated:** [October 22, 2010, 7:26am UTC](https://forum.inductiveautomation.com/t/insert-manually-alerts-in-alert-log-table/2273 "2010-10-22T07:26:43Z")
Is there any way to insert manually alerts in alert\_log table? We are working with a device that has its own alerts buffer. We are retrieving this alerts buffer and would like to insert them directly in the Ignition de… --- ## [Group Design for Data Cache](https://forum.inductiveautomation.com/t/group-design-for-data-cache/2239)
**Author:** [@fahadfrq](https://forum.inductiveautomation.com/u/fahadfrq)\ **Replies:** 7\ **Last updated:** [October 12, 2010, 6:35am UTC](https://forum.inductiveautomation.com/t/group-design-for-data-cache/2239 "2010-10-12T06:35:24Z")
Hi I need some information about working of buffered data cache incase of database failure in FactorySQL. I have version 4.2.12.0 in a redundancy configuration. I am creating sotred procedure groups with OPC items and … --- ## [Overlay issues](https://forum.inductiveautomation.com/t/overlay-issues/2241)
**Author:** [@jarlaxel](https://forum.inductiveautomation.com/u/jarlaxel)\ **Replies:** 1\ **Last updated:** [October 5, 2010, 7:18pm UTC](https://forum.inductiveautomation.com/t/overlay-issues/2241 "2010-10-05T19:18:35Z")
I have a list of numerical data coming from multiple machines that are being summed. When ever one of the machines is locked out for maintenance I get an overlay. I tried to bind the data quality on the summed bit to a… --- ## [SQL for finding SQLtags with "ACK MODE" set to "Auto"](https://forum.inductiveautomation.com/t/sql-for-finding-sqltags-with-ack-mode-set-to-auto/2231)
**Author:** [@rthomas](https://forum.inductiveautomation.com/u/rthomas)\ **Replies:** 1\ **Last updated:** [September 30, 2010, 3:32pm UTC](https://forum.inductiveautomation.com/t/sql-for-finding-sqltags-with-ack-mode-set-to-auto/2231 "2010-09-30T15:32:23Z")
I'd like to find the tags set to ackmode = auto, and change them to ackmode = Manual. Can you help me with this SQL. Thank you. --- ## [Gateway Error 312: SQLTags provider faulted Problem](https://forum.inductiveautomation.com/t/gateway-error-312-sqltags-provider-faulted-problem/2229)
**Author:** [@skallepalli](https://forum.inductiveautomation.com/u/skallepalli)\ **Replies:** 1\ **Last updated:** [September 29, 2010, 6:29pm UTC](https://forum.inductiveautomation.com/t/gateway-error-312-sqltags-provider-faulted-problem/2229 "2010-09-29T18:29:52Z")
Hi, We are facing very serious issue with Gateway Error 312: SQLTags provider faulted. The OPC Tags show Not Connected status (Red Color Tags) due to connectivity loss for every 2-3 sec. What would be the root cause … --- ## [Window and image caching](https://forum.inductiveautomation.com/t/window-and-image-caching/2210)
**Author:** [@chache](https://forum.inductiveautomation.com/u/chache)\ **Replies:** 1\ **Last updated:** [September 28, 2010, 8:07pm UTC](https://forum.inductiveautomation.com/t/window-and-image-caching/2210 "2010-09-28T20:07:11Z")
Hi all, I have a few questions about how caching is handled in FPMI and Ignition. Is it possible to cache larger images on the client's computer ahead of time, or is all that stuff brought down from the server when th… --- ## [Any 64 bit issues](https://forum.inductiveautomation.com/t/any-64-bit-issues/2203)
**Author:** [@DennisWomack](https://forum.inductiveautomation.com/u/DennisWomack)\ **Replies:** 3\ **Last updated:** [September 17, 2010, 8:55pm UTC](https://forum.inductiveautomation.com/t/any-64-bit-issues/2203 "2010-09-17T20:55:38Z")
My I/S dept is wanting to hand me a 64 bit server in our VMware enterprise. Their perferred Linux distribution is CentOS. Their managemnet tools, and backup are already installed. What are the issues I'll face with … --- ## [Cannot Launch One of Our Projects](https://forum.inductiveautomation.com/t/cannot-launch-one-of-our-projects/2175)
**Author:** [@Jonathan](https://forum.inductiveautomation.com/u/Jonathan)\ **Replies:** 1\ **Last updated:** [September 17, 2010, 6:02pm UTC](https://forum.inductiveautomation.com/t/cannot-launch-one-of-our-projects/2175 "2010-09-17T18:02:42Z")
When we try launching one of our saved projects we receive an error: \[quote\]Error loading project. org.xml.sax.SAXParseException: XML document structures must start and end within the same entity. \[/quote\] When I che… --- ## [IGNITION Gateway, OPC Server & MYSQL Server On Same Machine:](https://forum.inductiveautomation.com/t/ignition-gateway-opc-server-mysql-server-on-same-machine/1492)
**Author:** [@robin.abdul](https://forum.inductiveautomation.com/u/robin.abdul)\ **Replies:** 12\ **Last updated:** [September 17, 2010, 9:19am UTC](https://forum.inductiveautomation.com/t/ignition-gateway-opc-server-mysql-server-on-same-machine/1492 "2010-09-17T09:19:37Z")
hi. I would like to know if it is possible to run the IGNITION Gateway, OPC Server, MYSQL on the same machin, We are doing a project for one of our mill upgradation project Metals manufacturing unit, Continous manufa… --- ## [JAR resources in JNLP file are not ...; this issue persists](https://forum.inductiveautomation.com/t/jar-resources-in-jnlp-file-are-not-this-issue-persists/2199)
**Author:** [@GlennXS](https://forum.inductiveautomation.com/u/GlennXS)\ **Replies:** 1\ **Last updated:** [September 15, 2010, 3:24pm UTC](https://forum.inductiveautomation.com/t/jar-resources-in-jnlp-file-are-not-this-issue-persists/2199 "2010-09-15T15:24:58Z")
A few days ago, i downloaded and installed Unified Installer (FPMI) and Unified Updater and got the "JAR resources in JNLP file are not signed by same Certificate" error when i tried to launch the Designer. Then, I foll… --- ## [Print Report Multiple times with Sequence Number](https://forum.inductiveautomation.com/t/print-report-multiple-times-with-sequence-number/2172)
**Author:** [@Jonathan](https://forum.inductiveautomation.com/u/Jonathan)\ **Replies:** 1\ **Last updated:** [September 15, 2010, 12:40am UTC](https://forum.inductiveautomation.com/t/print-report-multiple-times-with-sequence-number/2172 "2010-09-15T00:40:28Z")
Is there a way I could print the report viewer multiple times while incrementing a number on the report? Say I have a input of the number of copies e.g. 10 and the number I want to start counting from e.g. 1000 . then… [Previous page](https://forum.inductiveautomation.com/c/archived-topics/9.md?page=13) [Next page](https://forum.inductiveautomation.com/c/archived-topics/9.md?page=15)