# Archived Topics **URL:** https://forum.inductiveautomation.com/c/archived-topics/9.md?page=16 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 17 --- ## [Gateway Error 500 on SQL Query](https://forum.inductiveautomation.com/t/gateway-error-500-on-sql-query/1922)
**Author:** [@bhastie](https://forum.inductiveautomation.com/u/bhastie)\ **Replies:** 3\ **Last updated:** [June 10, 2010, 5:56pm UTC](https://forum.inductiveautomation.com/t/gateway-error-500-on-sql-query/1922 "2010-06-10T17:56:09Z")
I have the following query which runs fine in MSSQL Management Studio, but will not even let me accept the query in Ignition. Select COALESCE(CAST (CASE WHEN (DatePart(mi,max(t\_stamp) - min(t\_stamp))) \<= 0 THEN 0 ELS… --- ## [Manual Alert Clear](https://forum.inductiveautomation.com/t/manual-alert-clear/1900)
**Author:** [@Jonathan](https://forum.inductiveautomation.com/u/Jonathan)\ **Replies:** 2\ **Last updated:** [June 9, 2010, 7:52pm UTC](https://forum.inductiveautomation.com/t/manual-alert-clear/1900 "2010-06-09T19:52:56Z")
I want an alert where if the value is 0 for more than 1 minute it sends an email. I know how to do that, but what I do not know how to do is not make the alert email if the condition happens again. I want the email to … --- ## [Viewing projects on mobile phones](https://forum.inductiveautomation.com/t/viewing-projects-on-mobile-phones/1874)
**Author:** [@andrewh](https://forum.inductiveautomation.com/u/andrewh)\ **Replies:** 2\ **Last updated:** [June 3, 2010, 11:32pm UTC](https://forum.inductiveautomation.com/t/viewing-projects-on-mobile-phones/1874 "2010-06-03T23:32:58Z")
Is anyone aware of phones that support logging into FactoryPMI projects? Even if there's a way to make a less featured, mobile version of the project. Thanks --- ## [Writing to DB using the runPrepStmt](https://forum.inductiveautomation.com/t/writing-to-db-using-the-runprepstmt/1872)
**Author:** [@mrtweaver](https://forum.inductiveautomation.com/u/mrtweaver)\ **Replies:** 2\ **Last updated:** [May 27, 2010, 3:26pm UTC](https://forum.inductiveautomation.com/t/writing-to-db-using-the-runprepstmt/1872 "2010-05-27T15:26:16Z")
Here is the code I have under a button. rec = 144 nm = event.source.parent.getComponent('customer name').text num = event.source.parent.getComponent('Customer Number').intValue cod = event.source.parent.getComponent('… --- ## [How to interact with Web Service?](https://forum.inductiveautomation.com/t/how-to-interact-with-web-service/1865)
**Author:** [@skallepalli](https://forum.inductiveautomation.com/u/skallepalli)\ **Replies:** 1\ **Last updated:** [May 25, 2010, 3:22pm UTC](https://forum.inductiveautomation.com/t/how-to-interact-with-web-service/1865 "2010-05-25T15:22:51Z")
Hi, We have a Test Web Service. This service takes 2 input parameters (Input 1, Input 2) and returns an Output (Output) which is a sum of Input 1 and Input 2. We tried to send the input parameters using fpmi.net.httpPo… --- ## [WinCE version of the JRE](https://forum.inductiveautomation.com/t/wince-version-of-the-jre/1852)
**Author:** [@DennisWomack](https://forum.inductiveautomation.com/u/DennisWomack)\ **Replies:** 1\ **Last updated:** [May 20, 2010, 11:35pm UTC](https://forum.inductiveautomation.com/t/wince-version-of-the-jre/1852 "2010-05-20T23:35:08Z")
Any news out of Sun/Oracle about a JRE for WinCE? Thanks Dennis --- ## [Add Header and Footer info to Print Job](https://forum.inductiveautomation.com/t/add-header-and-footer-info-to-print-job/1855)
**Author:** [@bhastie](https://forum.inductiveautomation.com/u/bhastie)\ **Replies:** 1\ **Last updated:** [May 20, 2010, 4:04pm UTC](https://forum.inductiveautomation.com/t/add-header-and-footer-info-to-print-job/1855 "2010-05-20T16:04:10Z")
I would like to add header and footer information to a print job. Current Code is as follows: #Print out an image of the current screen job = system.print.createPrintJob(event.source.parent) job.setMargins(0.5) job.z… --- ## [How will changing tag names in Kepware affect FSQL?](https://forum.inductiveautomation.com/t/how-will-changing-tag-names-in-kepware-affect-fsql/1840)
**Author:** [@TimE](https://forum.inductiveautomation.com/u/TimE)\ **Replies:** 3\ **Last updated:** [May 17, 2010, 5:24pm UTC](https://forum.inductiveautomation.com/t/how-will-changing-tag-names-in-kepware-affect-fsql/1840 "2010-05-17T17:24:31Z")
I am adding more production lines to the system and now want to change the tag naming scheme I am using. I will add a prefix to all tags indicating the production line. This will eliminate duplicate tag names. I also w… --- ## [Pie Chart Query Help](https://forum.inductiveautomation.com/t/pie-chart-query-help/1822)
**Author:** [@TimE](https://forum.inductiveautomation.com/u/TimE)\ **Replies:** 6\ **Last updated:** [May 17, 2010, 4:46pm UTC](https://forum.inductiveautomation.com/t/pie-chart-query-help/1822 "2010-05-17T16:46:29Z")
Following is a query I am trying to build to supply data to a pie chart. The pie chart is supposed to indicate the percent scrap of the current order. I just implemented this and found out that there are errors during a … --- ## [Scaling Problem](https://forum.inductiveautomation.com/t/scaling-problem/1842)
**Author:** [@larryjones](https://forum.inductiveautomation.com/u/larryjones)\ **Replies:** 6\ **Last updated:** [May 17, 2010, 3:55pm UTC](https://forum.inductiveautomation.com/t/scaling-problem/1842 "2010-05-17T15:55:26Z")
I've got a standard group in FactorySQL 4.2.12 which has about 500 OPC items. I'm getting an error message that says "The incoming tabular data stream (TDS) remote procedure call (RPC) protocol stream is incorrect. Para… --- ## [Table Structure Good or Bad?](https://forum.inductiveautomation.com/t/table-structure-good-or-bad/1806)
**Author:** [@jim\_lapratt](https://forum.inductiveautomation.com/u/jim_lapratt)\ **Replies:** 4\ **Last updated:** [May 14, 2010, 4:55pm UTC](https://forum.inductiveautomation.com/t/table-structure-good-or-bad/1806 "2010-05-14T16:55:17Z")
Here is a model I was planning on using to store employee data for : Clock in and out for day. Clock in and out for Breaks and lunch. And in future be able to track time clocked off jobs for other reasons throughout d… --- ## [Linux Alarm Notification Software](https://forum.inductiveautomation.com/t/linux-alarm-notification-software/1835)
**Author:** [@jgreenewv](https://forum.inductiveautomation.com/u/jgreenewv)\ **Replies:** 2\ **Last updated:** [May 14, 2010, 1:24pm UTC](https://forum.inductiveautomation.com/t/linux-alarm-notification-software/1835 "2010-05-14T13:24:45Z")
I have used products like SCADAlarm, SCADAPhone, and Win-911 on projects in the past, but all are Windows based. Does anyone know of, and preferably have experience with, any Linux based products that provide the same d… --- ## [Audit windows opened by users](https://forum.inductiveautomation.com/t/audit-windows-opened-by-users/1819)
**Author:** [@Jonathan](https://forum.inductiveautomation.com/u/Jonathan)\ **Replies:** 3\ **Last updated:** [May 7, 2010, 7:22pm UTC](https://forum.inductiveautomation.com/t/audit-windows-opened-by-users/1819 "2010-05-07T19:22:29Z")
I see there is a way to turn on auditing for projects and interactions to the database, but is there a way to keep a record of who, the name of a window, and when it was opened? --- ## [Time stamp is an hour off](https://forum.inductiveautomation.com/t/time-stamp-is-an-hour-off/1784)
**Author:** [@chris\_d\_sanders](https://forum.inductiveautomation.com/u/chris_d_sanders)\ **Replies:** 6\ **Last updated:** [May 7, 2010, 11:36am UTC](https://forum.inductiveautomation.com/t/time-stamp-is-an-hour-off/1784 "2010-05-07T11:36:23Z")
I believe since DST has occurred, we have been experiencing a BIZZAR tstamp issue. When running a query directly from MySQL: SELECT ID, crew, start\_time, stop\_time FROM rotation\_schedule WHERE start\_time BETWEEN '20… --- ## [Gateway Errors 500 & 304](https://forum.inductiveautomation.com/t/gateway-errors-500-304/1731)
**Author:** [@chris\_d\_sanders](https://forum.inductiveautomation.com/u/chris_d_sanders)\ **Replies:** 11\ **Last updated:** [May 7, 2010, 4:39am UTC](https://forum.inductiveautomation.com/t/gateway-errors-500-304/1731 "2010-05-07T04:39:03Z")
Haven't had much time lately to devote to our SERVER, but considering it crashed over the weekend, I've had to MAKE time. So, looking through the log, I found this: There are MORE than just this one Error. For example,… --- ## [Open file mutiple file type filter](https://forum.inductiveautomation.com/t/open-file-mutiple-file-type-filter/1820)
**Author:** [@Jonathan](https://forum.inductiveautomation.com/u/Jonathan)\ **Replies:** 1\ **Last updated:** [May 6, 2010, 10:23pm UTC](https://forum.inductiveautomation.com/t/open-file-mutiple-file-type-filter/1820 "2010-05-06T22:23:20Z")
Is there a way to pass multiple file extensions to the fpmi.file.openFile function? I want to filter the dialog box for more then just one file type. --- ## [Converting fpmi.gui.getWindowNames() to dataset](https://forum.inductiveautomation.com/t/converting-fpmi-gui-getwindownames-to-dataset/1809)
**Author:** [@TimE](https://forum.inductiveautomation.com/u/TimE)\ **Replies:** 3\ **Last updated:** [May 6, 2010, 3:27pm UTC](https://forum.inductiveautomation.com/t/converting-fpmi-gui-getwindownames-to-dataset/1809 "2010-05-06T15:27:52Z")
I want to put the results from fpmi.gui.getWindowNames() into a list. I made serveral incorrect attempts at trying to do this but I am still having difficulty figuring it out. I read through the old and new manuals but I… --- ## [Ignition Server Requirements](https://forum.inductiveautomation.com/t/ignition-server-requirements/1808)
**Author:** [@larryjones](https://forum.inductiveautomation.com/u/larryjones)\ **Replies:** 3\ **Last updated:** [May 5, 2010, 8:55pm UTC](https://forum.inductiveautomation.com/t/ignition-server-requirements/1808 "2010-05-05T20:55:56Z")
I'm looking at a project that will require just the SQL Bridge Module and the OPC Bridge Module. I've looked at the Ignition system requirements but wonder if Windows XP Embeded is sufficient. Your requirements are for… --- ## [Display options for docked windows](https://forum.inductiveautomation.com/t/display-options-for-docked-windows/1803)
**Author:** [@sorenrj](https://forum.inductiveautomation.com/u/sorenrj)\ **Replies:** 5\ **Last updated:** [May 4, 2010, 11:14pm UTC](https://forum.inductiveautomation.com/t/display-options-for-docked-windows/1803 "2010-05-04T23:14:41Z")
I have several windows containing EasyCharts. I would like to display a specific docked window for each window containing an EasyChart. I tried binding the 'visible' property of the docked window's Root Container to th… --- ## [How to move a Selected Value Up, Down in List Box?](https://forum.inductiveautomation.com/t/how-to-move-a-selected-value-up-down-in-list-box/1796)
**Author:** [@skallepalli](https://forum.inductiveautomation.com/u/skallepalli)\ **Replies:** 2\ **Last updated:** [May 4, 2010, 8:27am UTC](https://forum.inductiveautomation.com/t/how-to-move-a-selected-value-up-down-in-list-box/1796 "2010-05-04T08:27:43Z")
Hi, We are trying to implement a functionality where We want to move a Selected Value Up, Down in List component. We have seen this type of functionality in 'Filters' of Row Selector Customizer where We can specify t… --- ## [HOW-TO - FPMI on Ubuntu Server](https://forum.inductiveautomation.com/t/how-to-fpmi-on-ubuntu-server/1380)
**Author:** [@Kyle\_Chase](https://forum.inductiveautomation.com/u/Kyle_Chase)\ **Replies:** 6\ **Last updated:** [April 29, 2010, 5:56pm UTC](https://forum.inductiveautomation.com/t/how-to-fpmi-on-ubuntu-server/1380 "2010-04-29T17:56:22Z")
Ok, this is my attempt at a how to. No pictures... yet. I am assuming you already have Ubuntu server installed. The commands will look a little different for previous version of Ubuntu server, and I will fill in those… --- ## [How to group components?](https://forum.inductiveautomation.com/t/how-to-group-components/1776)
**Author:** [@skallepalli](https://forum.inductiveautomation.com/u/skallepalli)\ **Replies:** 6\ **Last updated:** [April 26, 2010, 2:16pm UTC](https://forum.inductiveautomation.com/t/how-to-group-components/1776 "2010-04-26T14:16:24Z")
Hi, Can we group two or more components(TextField, List, Button etc.) in FactoryPMI. --- ## [Can Linux/PC based PLCs make program changes on the fly?](https://forum.inductiveautomation.com/t/can-linux-pc-based-plcs-make-program-changes-on-the-fly/71)
**Author:** [@jeff\_anderson](https://forum.inductiveautomation.com/u/jeff_anderson)\ **Replies:** 4\ **Last updated:** [April 23, 2010, 9:15am UTC](https://forum.inductiveautomation.com/t/can-linux-pc-based-plcs-make-program-changes-on-the-fly/71 "2010-04-23T09:15:25Z")
I'm a big proponent of PC based PLCs (in theory) because you have so much more computing power and memory to deal with. However, every PLC I know of can make on-line edits while the system is running. It seems like compu… --- ## [MySQL Query Browser](https://forum.inductiveautomation.com/t/mysql-query-browser/1768)
**Author:** [@DB2](https://forum.inductiveautomation.com/u/DB2)\ **Replies:** 8\ **Last updated:** [April 23, 2010, 6:36am UTC](https://forum.inductiveautomation.com/t/mysql-query-browser/1768 "2010-04-23T06:36:30Z")
Does anyone know where to go, or do they have a copy, for a download of the MySQL Query Browser. I went to MySQL.com and they do not have it available. --- ## [Communicating to Unix System or PLC to get tags](https://forum.inductiveautomation.com/t/communicating-to-unix-system-or-plc-to-get-tags/1778)
**Author:** [@vinay](https://forum.inductiveautomation.com/u/vinay)\ **Replies:** 0\ **Last updated:** [April 22, 2010, 1:10pm UTC](https://forum.inductiveautomation.com/t/communicating-to-unix-system-or-plc-to-get-tags/1778 "2010-04-22T13:10:13Z")
Hi, We are having a ABB 450 & ABB MP200 Controller communicating to Unix System in one of our projects. Untill now we have done the communication with Siemens Wincc with windows DCOM settings and its working fine. Simi… --- ## [Reporting Plug in Help](https://forum.inductiveautomation.com/t/reporting-plug-in-help/1774)
**Author:** [@mrtweaver](https://forum.inductiveautomation.com/u/mrtweaver)\ **Replies:** 1\ **Last updated:** [April 21, 2010, 8:23pm UTC](https://forum.inductiveautomation.com/t/reporting-plug-in-help/1774 "2010-04-21T20:23:40Z")
I am working on a report using the plug in. On the designer I have my data and I have it set up under the group function. This way all relevant data from each row will be displayed on its own page. What I am trying to … --- ## [Incorrect indirect tag values and qualities](https://forum.inductiveautomation.com/t/incorrect-indirect-tag-values-and-qualities/1773)
**Author:** [@todd.be](https://forum.inductiveautomation.com/u/todd.be)\ **Replies:** 3\ **Last updated:** [April 21, 2010, 2:36am UTC](https://forum.inductiveautomation.com/t/incorrect-indirect-tag-values-and-qualities/1773 "2010-04-21T02:36:33Z")
We have a problem with a lot of our forms that we just noticed regarding indirect tags. We are running FPMI 3.3.1 (due to deployment problems we encountered when upgraded to latest version which might be related to sig… --- ## [Accessing gateway from two different IP ranges](https://forum.inductiveautomation.com/t/accessing-gateway-from-two-different-ip-ranges/1738)
**Author:** [@sydneydean](https://forum.inductiveautomation.com/u/sydneydean)\ **Replies:** 6\ **Last updated:** [April 20, 2010, 3:51pm UTC](https://forum.inductiveautomation.com/t/accessing-gateway-from-two-different-ip-ranges/1738 "2010-04-20T15:51:59Z")
We have a scenario where the customer wants the control network (PLC, HMIs) and their business network separated. Has anyone ever taken the path of installing two NICs into the server. Say for example one NIC is set t… --- ## [How to save XML file to a hypothetical URL?](https://forum.inductiveautomation.com/t/how-to-save-xml-file-to-a-hypothetical-url/1765)
**Author:** [@skallepalli](https://forum.inductiveautomation.com/u/skallepalli)\ **Replies:** 6\ **Last updated:** [April 20, 2010, 3:44pm UTC](https://forum.inductiveautomation.com/t/how-to-save-xml-file-to-a-hypothetical-url/1765 "2010-04-20T15:44:21Z")
Hi, We want to save the component values into XML file and save it on to a hypothetical URL. We tried with fpmi.file.writeFile(), which allows to save the file to Local drive but not to the URL. We also tried with fp… --- ## [Updating dataset?](https://forum.inductiveautomation.com/t/updating-dataset/1766)
**Author:** [@mrtweaver](https://forum.inductiveautomation.com/u/mrtweaver)\ **Replies:** 1\ **Last updated:** [April 19, 2010, 6:36pm UTC](https://forum.inductiveautomation.com/t/updating-dataset/1766 "2010-04-19T18:36:32Z")
From one screen I have an open and center popup screen where it sends over a 1 row by 14 column data set. This dataset is stored in the Root Container. What I am trying to do is figure out how to update one of the values… [Previous page](https://forum.inductiveautomation.com/c/archived-topics/9.md?page=15) [Next page](https://forum.inductiveautomation.com/c/archived-topics/9.md?page=17)