# Archived Topics **URL:** https://forum.inductiveautomation.com/c/archived-topics/9.md?page=32 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 33 --- ## [Export pdf files to desktop](https://forum.inductiveautomation.com/t/export-pdf-files-to-desktop/1043)
**Author:** [@DB2](https://forum.inductiveautomation.com/u/DB2)\ **Replies:** 2\ **Last updated:** [March 20, 2009, 1:32am UTC](https://forum.inductiveautomation.com/t/export-pdf-files-to-desktop/1043 "2009-03-20T01:32:07Z")
I'm having a problem with printing documents from PMI, it usally takes several minutes for the printer box to display and then for the document to print, the code I'm using is as follows: table = event.source.parent.ge… --- ## [runUpdateQuery](https://forum.inductiveautomation.com/t/runupdatequery/1045)
**Author:** [@mrtweaver](https://forum.inductiveautomation.com/u/mrtweaver)\ **Replies:** 3\ **Last updated:** [March 19, 2009, 10:10pm UTC](https://forum.inductiveautomation.com/t/runupdatequery/1045 "2009-03-19T22:10:59Z")
In the help file it says to use fpmi.db.runUpdateQuery for Insert, Update and Delete functions. Maybe I am missing a simple thing but I have tried used in the Delete and I get Here is the query as I have it laid out f… --- ## [Remote OPC Servers](https://forum.inductiveautomation.com/t/remote-opc-servers/1041)
**Author:** [@cbabb](https://forum.inductiveautomation.com/u/cbabb)\ **Replies:** 2\ **Last updated:** [March 18, 2009, 12:38pm UTC](https://forum.inductiveautomation.com/t/remote-opc-servers/1041 "2009-03-18T12:38:02Z")
Hopefully, I didn't miss something more informative on this subject... Can someone clarify the Remote OPC server setup information and the proper values the configuration panes are looking for? For example: Remote Ho… --- ## [Analog Issue](https://forum.inductiveautomation.com/t/analog-issue/1039)
**Author:** [@alai](https://forum.inductiveautomation.com/u/alai)\ **Replies:** 3\ **Last updated:** [March 17, 2009, 6:05pm UTC](https://forum.inductiveautomation.com/t/analog-issue/1039 "2009-03-17T18:05:52Z")
Has anyone seen this happen before? I have an MW406 set up in Kepware. I called that tag Auto\_Status(int2) in VisionLink, set it up with analog alerting and I get a 0(Cycle Complete) and a 1(Cycle Active) recorded at the… --- ## [Trigger group on DB value change](https://forum.inductiveautomation.com/t/trigger-group-on-db-value-change/1038)
**Author:** [@SonicClang](https://forum.inductiveautomation.com/u/SonicClang)\ **Replies:** 2\ **Last updated:** [March 16, 2009, 11:41pm UTC](https://forum.inductiveautomation.com/t/trigger-group-on-db-value-change/1038 "2009-03-16T23:41:33Z")
I know I've read about this (a while ago) and I'm sure it's possible. I don't have time to read through every post and try different search criteria to find the answer, so I'll just ask. Is it possible to trigger a gro… --- ## [Email alerts returning with unique error message](https://forum.inductiveautomation.com/t/email-alerts-returning-with-unique-error-message/1037)
**Author:** [@mrtweaver](https://forum.inductiveautomation.com/u/mrtweaver)\ **Replies:** 2\ **Last updated:** [March 14, 2009, 1:28am UTC](https://forum.inductiveautomation.com/t/email-alerts-returning-with-unique-error-message/1037 "2009-03-14T01:28:17Z")
Running FSQL 4.2.7 - To the best of my knowledge there was no configuration changes that occured in FSQL. In the past if a PLC stopped communications I would be notified via an email alert. During a recent issue where th… --- ## [Insert only when scale is on](https://forum.inductiveautomation.com/t/insert-only-when-scale-is-on/1036)
**Author:** [@Jonathan](https://forum.inductiveautomation.com/u/Jonathan)\ **Replies:** 1\ **Last updated:** [March 13, 2009, 4:07pm UTC](https://forum.inductiveautomation.com/t/insert-only-when-scale-is-on/1036 "2009-03-13T16:07:11Z")
I have a group that has one OPC item. I have it so that the OPC item updates a row in a table only when a change has occored and the update rate is 500ms. the problem i have is the value in the data base is a float and… --- ## [Compare date from drop down calendar to date in dataset](https://forum.inductiveautomation.com/t/compare-date-from-drop-down-calendar-to-date-in-dataset/1034)
**Author:** [@Jonathan](https://forum.inductiveautomation.com/u/Jonathan)\ **Replies:** 2\ **Last updated:** [March 13, 2009, 3:17pm UTC](https://forum.inductiveautomation.com/t/compare-date-from-drop-down-calendar-to-date-in-dataset/1034 "2009-03-13T15:17:59Z")
I am trying to manipulate a dataset in factoryPMI. I have a dataset that has a date column, a start date calendar component, and an end date calendar component. I would like to have a button that can be pressed that will… --- ## [Frontend Window Size](https://forum.inductiveautomation.com/t/frontend-window-size/1035)
**Author:** [@jimjohnson](https://forum.inductiveautomation.com/u/jimjohnson)\ **Replies:** 1\ **Last updated:** [March 12, 2009, 10:39pm UTC](https://forum.inductiveautomation.com/t/frontend-window-size/1035 "2009-03-12T22:39:39Z")
I am brand new to FactorySQL, but something that annoys me that I haven't found a way around is: every time I start the frontend, I have to resize the overall window size to what I like and then move the internal bar to… --- ## [Server died, Advice on restoring from backups?](https://forum.inductiveautomation.com/t/server-died-advice-on-restoring-from-backups/1032)
**Author:** [@Dravik](https://forum.inductiveautomation.com/u/Dravik)\ **Replies:** 8\ **Last updated:** [March 11, 2009, 8:01pm UTC](https://forum.inductiveautomation.com/t/server-died-advice-on-restoring-from-backups/1032 "2009-03-11T20:01:34Z")
So we had a major server failure that took my production FPMI install w/ it. After we restored from backups it seems to have lost all of its configs and whatnot. I have file level backups of everything, just wondering on… --- ## [Action script to loop through table and execute sproc](https://forum.inductiveautomation.com/t/action-script-to-loop-through-table-and-execute-sproc/1029)
**Author:** [@David](https://forum.inductiveautomation.com/u/David)\ **Replies:** 7\ **Last updated:** [March 9, 2009, 5:46pm UTC](https://forum.inductiveautomation.com/t/action-script-to-loop-through-table-and-execute-sproc/1029 "2009-03-09T17:46:45Z")
Hi All: I have a table that the user can input values in a couple of columns, for some or all rows. When the click a button I'd like to loop through the rows of the table and execute a stored procedure for any rows tha… --- ## [DateTime format changes in editable table](https://forum.inductiveautomation.com/t/datetime-format-changes-in-editable-table/1027)
**Author:** [@Ron](https://forum.inductiveautomation.com/u/Ron)\ **Replies:** 5\ **Last updated:** [March 6, 2009, 10:12pm UTC](https://forum.inductiveautomation.com/t/datetime-format-changes-in-editable-table/1027 "2009-03-06T22:12:32Z")
I have an editable table in my FPMI screen populated from the database. The columns in question are date fields formatted as "yyyy-MM-dd HH:mm:ss" When I click on the table field to edit the date, the displayed change… --- ## [Numeric text box property change executing on window close](https://forum.inductiveautomation.com/t/numeric-text-box-property-change-executing-on-window-close/1028)
**Author:** [@Jonathan](https://forum.inductiveautomation.com/u/Jonathan)\ **Replies:** 1\ **Last updated:** [March 6, 2009, 9:01pm UTC](https://forum.inductiveautomation.com/t/numeric-text-box-property-change-executing-on-window-close/1028 "2009-03-06T21:01:23Z")
I have a numeric text box that I would like to have update a database table when the property changes. the problem i am having is that when the window is closed the value in the table in the data base is updated to 0. … --- ## [Easy Chart Date Selector: outer range property?](https://forum.inductiveautomation.com/t/easy-chart-date-selector-outer-range-property/1025)
**Author:** [@karnick](https://forum.inductiveautomation.com/u/karnick)\ **Replies:** 1\ **Last updated:** [March 6, 2009, 5:50pm UTC](https://forum.inductiveautomation.com/t/easy-chart-date-selector-outer-range-property/1025 "2009-03-06T17:50:04Z")
I have an alarm history screen similar to that of the IA Demo application. On this screen I have a popup calendar that I use to let the user to jump to a new date range without having to constantly click the \< and \> on t… --- ## [Nested If](https://forum.inductiveautomation.com/t/nested-if/1026)
**Author:** [@DB2](https://forum.inductiveautomation.com/u/DB2)\ **Replies:** 3\ **Last updated:** [March 6, 2009, 5:13pm UTC](https://forum.inductiveautomation.com/t/nested-if/1026 "2009-03-06T17:13:48Z")
Not sure why this gives an error? x= int(event.source.text) y = int(event.source.parent.getComponent('qty').text) if (x \<= y): elif (x \>= 5): event.source.validsp1tot = 1 else: event.source.validsp1tot = … --- ## [Duplicate Alerts?](https://forum.inductiveautomation.com/t/duplicate-alerts/1023)
**Author:** [@karnick](https://forum.inductiveautomation.com/u/karnick)\ **Replies:** 2\ **Last updated:** [March 4, 2009, 2:03pm UTC](https://forum.inductiveautomation.com/t/duplicate-alerts/1023 "2009-03-04T14:03:39Z")
I'm coming to find that half my inquiries have to do with alerts. Anyway, this one is simple. Sometimes I am getting duplicate alerts when some of my tags enter an alarm state. The alarm times are either the exact same t… --- ## [Water System Operation Notes Page](https://forum.inductiveautomation.com/t/water-system-operation-notes-page/1014)
**Author:** [@Henry](https://forum.inductiveautomation.com/u/Henry)\ **Replies:** 3\ **Last updated:** [March 3, 2009, 10:54pm UTC](https://forum.inductiveautomation.com/t/water-system-operation-notes-page/1014 "2009-03-03T22:54:10Z")
I would like to create an operational notes page where the distribution system operator can type in information like pump out of service and save the text so that it can be displayed on any client system. Is this possibl… --- ## [CTG and IA Demo](https://forum.inductiveautomation.com/t/ctg-and-ia-demo/1015)
**Author:** [@Henry](https://forum.inductiveautomation.com/u/Henry)\ **Replies:** 3\ **Last updated:** [March 3, 2009, 10:13pm UTC](https://forum.inductiveautomation.com/t/ctg-and-ia-demo/1015 "2009-03-03T22:13:27Z")
Add the click to graph goodie to future versions in the IA Demo. --- ## [Random "Datasource is FAULTED" errors](https://forum.inductiveautomation.com/t/random-datasource-is-faulted-errors/1006)
**Author:** [@karnick](https://forum.inductiveautomation.com/u/karnick)\ **Replies:** 3\ **Last updated:** [March 3, 2009, 5:40pm UTC](https://forum.inductiveautomation.com/t/random-datasource-is-faulted-errors/1006 "2009-03-03T17:40:29Z")
I've been spending some time trying to fix this one on my own, but it looks like I will have to give in to the support system again. In a given window in my application I have a reporting plugin and a date range selec… --- ## [Accessing a RS 232 Device from a Factory PMI Client](https://forum.inductiveautomation.com/t/accessing-a-rs-232-device-from-a-factory-pmi-client/1007)
**Author:** [@vipulss](https://forum.inductiveautomation.com/u/vipulss)\ **Replies:** 1\ **Last updated:** [March 2, 2009, 8:26pm UTC](https://forum.inductiveautomation.com/t/accessing-a-rs-232-device-from-a-factory-pmi-client/1007 "2009-03-02T20:26:11Z")
I want to access RS 232 Device from inside a Factory PMI client because the RS 232 device will be connected to the client. I read this post on this issue: viewtopic.php?f=23&t=3958 However I want to know the possibi… --- ## [Runtime query over midnight hour issue](https://forum.inductiveautomation.com/t/runtime-query-over-midnight-hour-issue/957)
**Author:** [@mrtweaver](https://forum.inductiveautomation.com/u/mrtweaver)\ **Replies:** 3\ **Last updated:** [March 2, 2009, 8:23pm UTC](https://forum.inductiveautomation.com/t/runtime-query-over-midnight-hour-issue/957 "2009-03-02T20:23:03Z")
I am working on a report that tabulates data from the MS-SQL server. The problem I am having is when it crosses over the midnight hour. From 12:01am till 11:59pm my query runs nice and shows what I need, but it bombs out… --- ## [Null Pointer exception errors and gateway disconnect errors](https://forum.inductiveautomation.com/t/null-pointer-exception-errors-and-gateway-disconnect-errors/1000)
**Author:** [@mrtweaver](https://forum.inductiveautomation.com/u/mrtweaver)\ **Replies:** 2\ **Last updated:** [March 2, 2009, 4:12pm UTC](https://forum.inductiveautomation.com/t/null-pointer-exception-errors-and-gateway-disconnect-errors/1000 "2009-03-02T16:12:43Z")
I have attached the playground screen where I do my testing and designing before implementing in the project. The problem I am having is two fold and it might even have to do with the previous posted error about a value … --- ## [fpmi.db.ScalarQuery with varibales](https://forum.inductiveautomation.com/t/fpmi-db-scalarquery-with-varibales/1017)
**Author:** [@DB2](https://forum.inductiveautomation.com/u/DB2)\ **Replies:** 1\ **Last updated:** [February 26, 2009, 7:02pm UTC](https://forum.inductiveautomation.com/t/fpmi-db-scalarquery-with-varibales/1017 "2009-02-26T19:02:31Z")
I need to return a value using a scalar query, here is an example of what I'm trying to do: zo = 10 pt = 4366 Pclass = event.source.parent.getComponent('product class').text Pclass is set to 'class\_2', which is a col… --- ## [HTML add variable to string question](https://forum.inductiveautomation.com/t/html-add-variable-to-string-question/1016)
**Author:** [@mrtweaver](https://forum.inductiveautomation.com/u/mrtweaver)\ **Replies:** 4\ **Last updated:** [February 26, 2009, 12:37am UTC](https://forum.inductiveautomation.com/t/html-add-variable-to-string-question/1016 "2009-02-26T00:37:06Z")
I am attempting something that I thought had been previously addressed but can not find the link to it. I am using the exportToHTML in the table component. I want to add another string of HTML to the table component befo… --- ## [Movable container](https://forum.inductiveautomation.com/t/movable-container/1013)
**Author:** [@Jonathan](https://forum.inductiveautomation.com/u/Jonathan)\ **Replies:** 1\ **Last updated:** [February 24, 2009, 8:55pm UTC](https://forum.inductiveautomation.com/t/movable-container/1013 "2009-02-24T20:55:40Z")
Rather than creating another window in my project I created a container that becomes visible. This technique works find except now the end user has requested the container be movable. Is there a way I can make the cont… --- ## [Newbie Help](https://forum.inductiveautomation.com/t/newbie-help/1010)
**Author:** [@Sam\_P](https://forum.inductiveautomation.com/u/Sam_P)\ **Replies:** 3\ **Last updated:** [February 23, 2009, 8:56am UTC](https://forum.inductiveautomation.com/t/newbie-help/1010 "2009-02-23T08:56:21Z")
Hi, I am trying to evaluate SQL & PMI for use as a site wide data aquisition system to collect OEE information. I have used other products like Citect, RSview32, etc but have never used python. I have loaded the demo app… --- ## [SQL dbTag or runQuery?](https://forum.inductiveautomation.com/t/sql-dbtag-or-runquery/1008)
**Author:** [@TimE](https://forum.inductiveautomation.com/u/TimE)\ **Replies:** 2\ **Last updated:** [February 20, 2009, 11:07pm UTC](https://forum.inductiveautomation.com/t/sql-dbtag-or-runquery/1008 "2009-02-20T23:07:12Z")
Background: Nearly all of the data I am working with are process variables and setpoints that are stored in historical tables. The graphing of this data is based on a modified version of the \[del\]easy chart\[/del\] Click-t… --- ## [Custom query or script help](https://forum.inductiveautomation.com/t/custom-query-or-script-help/1009)
**Author:** [@TimE](https://forum.inductiveautomation.com/u/TimE)\ **Replies:** 1\ **Last updated:** [February 20, 2009, 10:00pm UTC](https://forum.inductiveautomation.com/t/custom-query-or-script-help/1009 "2009-02-20T22:00:47Z")
I am trying to build a table from two different queries. The first query is: data = fpmi.db.runQuery("SELECT Count(\*) as 'Records', min(t\_stamp) as 'Start', max(t\_stamp) as 'Stop', max(t\_stamp) - min(t\_stamp) as 'Dur… --- ## [Hyper Terminal](https://forum.inductiveautomation.com/t/hyper-terminal/580)
**Author:** [@raw1312](https://forum.inductiveautomation.com/u/raw1312)\ **Replies:** 6\ **Last updated:** [February 19, 2009, 10:57pm UTC](https://forum.inductiveautomation.com/t/hyper-terminal/580 "2009-02-19T22:57:40Z")
I need to grab some data that is being sent to hyper terminal. How could I do this? --- ## [Multiple SQLTags Configurations](https://forum.inductiveautomation.com/t/multiple-sqltags-configurations/1001)
**Author:** [@karnick](https://forum.inductiveautomation.com/u/karnick)\ **Replies:** 5\ **Last updated:** [February 19, 2009, 7:35pm UTC](https://forum.inductiveautomation.com/t/multiple-sqltags-configurations/1001 "2009-02-19T19:35:53Z")
I am looking to run multiple (different) applications on my gateway for different customers. However, I noticed that the SQLTags configuration in FactorySQL only allows me to specify a single data connection. I am basica… [Previous page](https://forum.inductiveautomation.com/c/archived-topics/9.md?page=31) [Next page](https://forum.inductiveautomation.com/c/archived-topics/9.md?page=33)