# Archived Topics **URL:** https://forum.inductiveautomation.com/c/archived-topics/9.md?page=26 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 27 --- ## [Help with an Action Item SQL Query](https://forum.inductiveautomation.com/t/help-with-an-action-item-sql-query/1242)
**Author:** [@HandledException](https://forum.inductiveautomation.com/u/HandledException)\ **Replies:** 15\ **Last updated:** [August 14, 2009, 4:34pm UTC](https://forum.inductiveautomation.com/t/help-with-an-action-item-sql-query/1242 "2009-08-14T16:34:09Z")
Hello, I am in need of some help from you FSQL veterans out there! :wink: My overall goal is to convert an array of integers symbolizing the date and time from the plc, into a DateTime which the database can understa… --- ## [Change datasources dynamically](https://forum.inductiveautomation.com/t/change-datasources-dynamically/914)
**Author:** [@skenealy](https://forum.inductiveautomation.com/u/skenealy)\ **Replies:** 3\ **Last updated:** [August 13, 2009, 9:37pm UTC](https://forum.inductiveautomation.com/t/change-datasources-dynamically/914 "2009-08-13T21:37:32Z")
I'd like to set up something where I can pick a datasource from a drop-down menu during runtime. When binding properties, I know there is a drop-down to choose which datasource to use, but I won't be able to change this … --- ## [Using action items](https://forum.inductiveautomation.com/t/using-action-items/1244)
**Author:** [@Jonathan](https://forum.inductiveautomation.com/u/Jonathan)\ **Replies:** 2\ **Last updated:** [August 13, 2009, 6:55pm UTC](https://forum.inductiveautomation.com/t/using-action-items/1244 "2009-08-13T18:55:15Z")
I am definitely a novice when it comes to FactorySQL so let me explain the situation first. We have been inserting information from a device into the database every 30 seconds. The fields that are inserted are: ndx … --- ## [Stored Proceedure Variable assistance please](https://forum.inductiveautomation.com/t/stored-proceedure-variable-assistance-please/1245)
**Author:** [@mrtweaver](https://forum.inductiveautomation.com/u/mrtweaver)\ **Replies:** 2\ **Last updated:** [August 13, 2009, 5:50pm UTC](https://forum.inductiveautomation.com/t/stored-proceedure-variable-assistance-please/1245 "2009-08-13T17:50:44Z")
I dont know if this is possible or not so I thought I would post it here and see what information can be received. I have built a Stored Proceedure in MS SQL, this proceedure will get its data from a massive table (cur… --- ## [Upgrading](https://forum.inductiveautomation.com/t/upgrading/1246)
**Author:** [@mrtweaver](https://forum.inductiveautomation.com/u/mrtweaver)\ **Replies:** 1\ **Last updated:** [August 13, 2009, 4:54pm UTC](https://forum.inductiveautomation.com/t/upgrading/1246 "2009-08-13T16:54:55Z")
I was wondering if there had been any thought into having an upgrade via web section in the FPMI gateway configuration. I know that when you install the software it asks if you want to go out on the web and check for a m… --- ## [Touchscreen keyboard doesn't popup for Easy Chart time range](https://forum.inductiveautomation.com/t/touchscreen-keyboard-doesnt-popup-for-easy-chart-time-range/1247)
**Author:** [@eaolson](https://forum.inductiveautomation.com/u/eaolson)\ **Replies:** 1\ **Last updated:** [August 13, 2009, 4:51pm UTC](https://forum.inductiveautomation.com/t/touchscreen-keyboard-doesnt-popup-for-easy-chart-time-range/1247 "2009-08-13T16:51:06Z")
When running in touchscreen mode, a screen keyboard pops up when text and numeric components get focus. The Easy Chart widget has a "Selected date range" text input box that does not cause this keyboard to appear. I'm as… --- ## [Java Launch Certificate Issues](https://forum.inductiveautomation.com/t/java-launch-certificate-issues/1243)
**Author:** [@Carl.Gould](https://forum.inductiveautomation.com/u/Carl.Gould)\ **Replies:** 3\ **Last updated:** [August 12, 2009, 8:12pm UTC](https://forum.inductiveautomation.com/t/java-launch-certificate-issues/1243 "2009-08-12T20:12:48Z")
Hello everyone, We are currently experiencing frequent support issues from two separate but related issues with regards to our FactoryPMI launch certificates. Issue #1 - "The digital signature was generated with a tr… --- ## [Any way to control tooltip on Chart](https://forum.inductiveautomation.com/t/any-way-to-control-tooltip-on-chart/1184)
**Author:** [@Ron](https://forum.inductiveautomation.com/u/Ron)\ **Replies:** 3\ **Last updated:** [August 7, 2009, 10:26pm UTC](https://forum.inductiveautomation.com/t/any-way-to-control-tooltip-on-chart/1184 "2009-08-07T22:26:00Z")
I have a chart that shows three different datasets. It is an XY Plot type. They all share the same X-axis, which is a number of hours a process has run. The datasets all have two columns, the first is the x value and … --- ## [Read PLC Timestamp into FSQL via KepServerEx](https://forum.inductiveautomation.com/t/read-plc-timestamp-into-fsql-via-kepserverex/1241)
**Author:** [@HandledException](https://forum.inductiveautomation.com/u/HandledException)\ **Replies:** 2\ **Last updated:** [August 7, 2009, 7:07pm UTC](https://forum.inductiveautomation.com/t/read-plc-timestamp-into-fsql-via-kepserverex/1241 "2009-08-07T19:07:51Z")
Hello Everyone, I just started trying out FSQL with the hopes of replacing a troublesome RSSQL setup and have a quick question. In RSSQL you can create a PLC Timestamp reference by passing in an array of 7 Ints. Then… --- ## [How does the Client\_ID get set in Click-to-Graph?](https://forum.inductiveautomation.com/t/how-does-the-client-id-get-set-in-click-to-graph/1239)
**Author:** [@TheRicster](https://forum.inductiveautomation.com/u/TheRicster)\ **Replies:** 3\ **Last updated:** [August 6, 2009, 3:46pm UTC](https://forum.inductiveautomation.com/t/how-does-the-client-id-get-set-in-click-to-graph/1239 "2009-08-06T15:46:06Z")
I'm trying to figure out how the Client\_ID dynamic property of the Click To Graph Root Container gets set when the window is opened. I realize there is a function fpmi.system.getClientID(), but I'm not seeing where or h… --- ## [Add line breaks to email alerts](https://forum.inductiveautomation.com/t/add-line-breaks-to-email-alerts/1240)
**Author:** [@Ron](https://forum.inductiveautomation.com/u/Ron)\ **Replies:** 0\ **Last updated:** [August 5, 2009, 5:30pm UTC](https://forum.inductiveautomation.com/t/add-line-breaks-to-email-alerts/1240 "2009-08-05T17:30:18Z")
Is there a way to format the emailed alert messages. Currently I am inclucing several parameters in the alert and would like them to each be on a seperate line. I have the following custom message: CO2 Plant Tank Leve… --- ## [Event Meter](https://forum.inductiveautomation.com/t/event-meter/1238)
**Author:** [@JordanCClark](https://forum.inductiveautomation.com/u/JordanCClark)\ **Replies:** 3\ **Last updated:** [August 5, 2009, 5:28pm UTC](https://forum.inductiveautomation.com/t/event-meter/1238 "2009-08-05T17:28:20Z")
Ok, This should be straightforward, but I must be having a "duh" moment. While I already feel like an idiot for not figuring this out, I won't mind feeling like a bigger idiot if you guys can point in the right directio… --- ## [Post what you know about ISA-SP95](https://forum.inductiveautomation.com/t/post-what-you-know-about-isa-sp95/61)
**Author:** [@integrator\_adam72](https://forum.inductiveautomation.com/u/integrator_adam72)\ **Replies:** 2\ **Last updated:** [August 3, 2009, 10:13pm UTC](https://forum.inductiveautomation.com/t/post-what-you-know-about-isa-sp95/61 "2009-08-03T22:13:06Z")
Anyone know what the ISA-SP95 committe has been up to? They're working on Enterprise-Control System Integration standards. --- ## [What's the ideal computer to run FactorySQL and FactoryPMI?](https://forum.inductiveautomation.com/t/whats-the-ideal-computer-to-run-factorysql-and-factorypmi/20)
**Author:** [@jeff\_anderson](https://forum.inductiveautomation.com/u/jeff_anderson)\ **Replies:** 13\ **Last updated:** [August 3, 2009, 2:38pm UTC](https://forum.inductiveautomation.com/t/whats-the-ideal-computer-to-run-factorysql-and-factorypmi/20 "2009-08-03T14:38:57Z")
Should I use the same machine for both FactoryPMI and FactorySQL? What should I be concerned about when planing a server? --- ## [Export data into MSExcel](https://forum.inductiveautomation.com/t/export-data-into-msexcel/1234)
**Author:** [@hgeps](https://forum.inductiveautomation.com/u/hgeps)\ **Replies:** 5\ **Last updated:** [August 1, 2009, 3:57am UTC](https://forum.inductiveautomation.com/t/export-data-into-msexcel/1234 "2009-08-01T03:57:08Z")
I have an application where the user enters the data in a window and I would like to log the user data in an Excel application. I would like to log each data point in a specific cell in the Excel spreadsheet. Is this ca… --- ## [Independent Boundaries on Numeric Text Field](https://forum.inductiveautomation.com/t/independent-boundaries-on-numeric-text-field/1235)
**Author:** [@skenealy](https://forum.inductiveautomation.com/u/skenealy)\ **Replies:** 3\ **Last updated:** [July 31, 2009, 3:48am UTC](https://forum.inductiveautomation.com/t/independent-boundaries-on-numeric-text-field/1235 "2009-07-31T03:48:26Z")
Got a small request here... add options for boundaries on numeric text field component to use just an upper or just a lower bound. Most obvious example of this would be to restrict values to the set of natural numbers. S… --- ## [Querying a local MySQL database](https://forum.inductiveautomation.com/t/querying-a-local-mysql-database/1233)
**Author:** [@Henry](https://forum.inductiveautomation.com/u/Henry)\ **Replies:** 3\ **Last updated:** [July 30, 2009, 3:32pm UTC](https://forum.inductiveautomation.com/t/querying-a-local-mysql-database/1233 "2009-07-30T15:32:34Z")
I’m trying to query a local MySQL database using Excel. I was successful at installing MySQL driver and I have the right logon and password. However, the query comes back and says that I have no visible tables. I also t… --- ## [SQL Query not working](https://forum.inductiveautomation.com/t/sql-query-not-working/1232)
**Author:** [@Jonathan](https://forum.inductiveautomation.com/u/Jonathan)\ **Replies:** 7\ **Last updated:** [July 28, 2009, 9:32pm UTC](https://forum.inductiveautomation.com/t/sql-query-not-working/1232 "2009-07-28T21:32:06Z")
I am trying to populate a drop down with available tables in a database. in management studio I can use this query: SELECT TABLE\_NAME FROM INFORMATION\_SCHEMA.TABLES When I bind that to the data property of the drop dow… --- ## [escapeSQL and escapeXML](https://forum.inductiveautomation.com/t/escapesql-and-escapexml/1230)
**Author:** [@Jonathan](https://forum.inductiveautomation.com/u/Jonathan)\ **Replies:** 1\ **Last updated:** [July 27, 2009, 5:25pm UTC](https://forum.inductiveautomation.com/t/escapesql-and-escapexml/1230 "2009-07-27T17:25:48Z")
What do these functions do in the expression language? I cannot find them in the user manual. --- ## [IP PTZ Cameras and FPMI](https://forum.inductiveautomation.com/t/ip-ptz-cameras-and-fpmi/1229)
**Author:** [@MickeyBob](https://forum.inductiveautomation.com/u/MickeyBob)\ **Replies:** 1\ **Last updated:** [July 27, 2009, 3:20pm UTC](https://forum.inductiveautomation.com/t/ip-ptz-cameras-and-fpmi/1229 "2009-07-27T15:20:00Z")
I would like to solicit input regarding the following questions on IP PTZ cameras: What IP PTZ cameras have people been able to integrate successfully with FPMI? What are the challenges one can expect to encounter? … --- ## [Report designer dynamic properties 'isvisible'](https://forum.inductiveautomation.com/t/report-designer-dynamic-properties-isvisible/1227)
**Author:** [@cl1234](https://forum.inductiveautomation.com/u/cl1234)\ **Replies:** 4\ **Last updated:** [July 25, 2009, 12:23am UTC](https://forum.inductiveautomation.com/t/report-designer-dynamic-properties-isvisible/1227 "2009-07-25T00:23:48Z")
In designing a report, I would like to make an object invisible when a key string is null. According to the Dynamic Example section here: inductiveautomation.com/prod ... sermanual/ the isVisible property should be able … --- ## [More robust threading](https://forum.inductiveautomation.com/t/more-robust-threading/1208)
**Author:** [@skenealy](https://forum.inductiveautomation.com/u/skenealy)\ **Replies:** 9\ **Last updated:** [July 23, 2009, 9:52pm UTC](https://forum.inductiveautomation.com/t/more-robust-threading/1208 "2009-07-23T21:52:47Z")
We've been working on a project that utilizes diagnostic tests on equipment that can take on the order of an hour. These tests have python scripts associated with them which are fired off in separate threads using the in… --- ## [Python Classes](https://forum.inductiveautomation.com/t/python-classes/1221)
**Author:** [@Jonathan](https://forum.inductiveautomation.com/u/Jonathan)\ **Replies:** 2\ **Last updated:** [July 23, 2009, 7:43pm UTC](https://forum.inductiveautomation.com/t/python-classes/1221 "2009-07-23T19:43:48Z")
I am curious as to why this does not work. I have created a class called MyClass in the global script package app.object class MyClass: instancesCreated = 0 def \_\_init\_\_(self, initialValue=0): MyClass.instancesCr… --- ## [Non-editable input editable when using touchscreen - bug?](https://forum.inductiveautomation.com/t/non-editable-input-editable-when-using-touchscreen-bug/1226)
**Author:** [@eaolson](https://forum.inductiveautomation.com/u/eaolson)\ **Replies:** 1\ **Last updated:** [July 22, 2009, 8:44pm UTC](https://forum.inductiveautomation.com/t/non-editable-input-editable-when-using-touchscreen-bug/1226 "2009-07-22T20:44:32Z")
I have a numeric text field, which is enabled, but not editable. (I didn't want to disable it, because that greys it out and makes the text a bit more difficult to read.) When I'm in preview mode, I can put the cursor i… --- ## [Dynamic queries](https://forum.inductiveautomation.com/t/dynamic-queries/1225)
**Author:** [@Step7](https://forum.inductiveautomation.com/u/Step7)\ **Replies:** 3\ **Last updated:** [July 21, 2009, 3:41pm UTC](https://forum.inductiveautomation.com/t/dynamic-queries/1225 "2009-07-21T15:41:25Z")
I've got a situation where my insert queries really need to be dynamic, and was wondering if I am going about this correctly. I won't know the number of columns or data types until I actually execute the code. This is … --- ## [An acceptable version of java was not found](https://forum.inductiveautomation.com/t/an-acceptable-version-of-java-was-not-found/1223)
**Author:** [@TimE](https://forum.inductiveautomation.com/u/TimE)\ **Replies:** 11\ **Last updated:** [July 20, 2009, 7:07pm UTC](https://forum.inductiveautomation.com/t/an-acceptable-version-of-java-was-not-found/1223 "2009-07-20T19:07:44Z")
Some of our clients have recently installed java update 14 and everything quit working. I reviewed this post... http://www.inductiveautomation.com/forum/viewtopic.php?f=26&t=2685 then I deleted the reporting plugin and… --- ## [SQL Tags Alert Description dynamic function](https://forum.inductiveautomation.com/t/sql-tags-alert-description-dynamic-function/1212)
**Author:** [@david\_mccutchen](https://forum.inductiveautomation.com/u/david_mccutchen)\ **Replies:** 4\ **Last updated:** [July 17, 2009, 1:51am UTC](https://forum.inductiveautomation.com/t/sql-tags-alert-description-dynamic-function/1212 "2009-07-17T01:51:30Z")
It would be helpful if the state name of an sql tag could display dynamic values from other sources such as other sql tags, database tags, etc. For example I have an alarm that gives "some" text description that I also w… --- ## [Redundancy Failover Alert](https://forum.inductiveautomation.com/t/redundancy-failover-alert/1205)
**Author:** [@larryjones](https://forum.inductiveautomation.com/u/larryjones)\ **Replies:** 5\ **Last updated:** [July 17, 2009, 1:26am UTC](https://forum.inductiveautomation.com/t/redundancy-failover-alert/1205 "2009-07-17T01:26:35Z")
We've got two FactorySQL nodes running in redundant mode and logging to Microsoft SQL Server. What's the best way to send an email alert when the secondary node's mode changes from "Backup" to either "Provisional Master… --- ## [FPMI Windows startup script](https://forum.inductiveautomation.com/t/fpmi-windows-startup-script/1222)
**Author:** [@hgeps](https://forum.inductiveautomation.com/u/hgeps)\ **Replies:** 1\ **Last updated:** [July 16, 2009, 9:16pm UTC](https://forum.inductiveautomation.com/t/fpmi-windows-startup-script/1222 "2009-07-16T21:16:15Z")
How can I configure a script to run whenever a window is displayed? --- ## [Intellisense](https://forum.inductiveautomation.com/t/intellisense/1031)
**Author:** [@Jonathan](https://forum.inductiveautomation.com/u/Jonathan)\ **Replies:** 4\ **Last updated:** [July 15, 2009, 10:04pm UTC](https://forum.inductiveautomation.com/t/intellisense/1031 "2009-07-15T22:04:21Z")
Would it be possible to include something similar to intellisense in FPMI? This would be useful in both the jython section and the expression language. I find I have to constantly click on the function button to see wh… [Previous page](https://forum.inductiveautomation.com/c/archived-topics/9.md?page=25) [Next page](https://forum.inductiveautomation.com/c/archived-topics/9.md?page=27)